Hi
try this in O3

=IF(ISNA(VLOOKUP(U2,'Financial
itininary'!$C$475:$G$5000,5,0)),"",VLOOKUP(U2,'Fin ancial
itininary'!$C$475:$G$5000,5,0))

you may need to expand your range of lookup table

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"stew" wrote:

Hi All

This vlookup formula is to be located inFinancialsO3

I have a Date on work sheet €˜FinancialsU2.This date will always be in
€˜FinancialsU2. I want to use this date in a vlookup function as my
lookup value
I want to look up in worksheet €˜financial itininary column c. the dates on
this worksheet start appearing in C475 advances on a daily every 49TH
row. When it is found the value I want to return is in column G. This figure
first appears in G479 and grows in value every 49th row.

I cannot get my head round the formula.
Hope someone can help

Stew