I have tried that but I still have the same error.

"Jacob Skaria" wrote:

Try with a defined range....

=VLOOKUP($B38,Roster!$B1:$F1000,2,FALSE)

If this post helps click Yes
---------------
Jacob Skaria


"mind_killer" wrote:

Hi,
I have the opposite problem of some of those here. VLOOKUP is returning #N/A
when it should be returning a value.

The formula I am using is:
=VLOOKUP($B38,Roster!$B:$F,2,TRUE)

The lookup value is a date, I have been playing around with the format but
it has not fixed it.

Thanks