Look up with different date formats

[Westbury]

I have a table with dates in format d/mmm and data in second column. I would like to use this in a lookup using dates in any year so I'm searching for a result against d/mmm/yy. Vlookup doesn't work; is there a work around?

Geoff

 

[Scott T]

Regardless of what format a date has it has a year, it just may not be visible in the cell. The lookup value in vlookup should have the year

Excel 2010
	A	B
5	7/Jan	7
6	9/Jan	99
7
8
9	1/7/2017	7
Sheet2

Cell Formulas
Range	Formula
B9	=VLOOKUP(A9,A5:B6,2,0)

 

[SpillerBD]

I am going to guess that you have text values that you are trying to compare to number values (date serial numbers). LOOKUP functions can only compare the same data types. So looking up Text, that looks like a date, in a series of actual dates will always return #NA .

Workarounds are always to change or add a like value type in one of those Tables.
Text-To-Columns
VALUE()
TEXT()