Thread: Excel or Access
View Single Post
 
Old 07-10-2017, 09:22 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
How about:

LOOKUP(2,1/($F$2:$F$8=$N$2),$C$2:$C$8)

withe venue to look up in N2 venues in F2:F8 and dates in C2:C8.
Reply With Quote