Excel or Access

		Microsoft Office Forums > Microsoft Excel > Excel
Excel or Access

07-10-2017, 09:22 AM

xor

Windows 10 Excel or Access

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel or Access for DB?	John H. Power	Word	3	08-03-2016 11:52 AM
Excel to Access to Excel for report automation	Nicholaspoe	Excel Programming	10	10-08-2013 08:13 PM
Access or Excel?	hektisk	Office	11	04-11-2011 04:24 PM
Should I uses Access or Excel?	tinkertron	Office	5	03-29-2009 08:30 PM
Excel or Access ?	inferno	Excel	0	10-03-2008 03:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:16 PM.