Vlookup - text date cell

[dunmore83]

Hi,

I have a simple Vlookup formula as follows;

=VLOOKUP(D4,'Milk-Prices'!$G$10:$S$21,4,0)

However D4 is formatted as a date text cell as follows;

="DAILY INCOME RESULTS - "&TEXT('P01-Summary'!M20,"dd mmm yy")

The vlookup formula is returning #N/A however if I simply format cell D4 as a straight date cell (i.e. [$-C09]dd-mmm-yy;@) the vlookup function works.

Is there a workaround here so the vlookup works when referencing a cell with text that is formatted as a date cell ?

Thanks

 

[FormR]

Hi, can't you use the unformatted date from the P01-Summary sheet? i.e.

=VLOOKUP('P01-Summary'!M20,'Milk-Prices'!$G$10:$S$21,4,0)

 

[dunmore83]

That's any easy solution! Thanks