I am guessing here...

The lookup value must be formatted differently. Not the data you want to
fill. The data you use to refer to it with... The "key" data.

$B38 is formatted differently than the cell in the lookup range. OR B38
is empty, and you are offset from what you think your lookup key cell
location is. OR the key lookup value is not in the lookup data range
named. It has to be the first column of the range as well.



On Thu, 11 Jun 2009 20:39:01 -0700, mind_killer
wrote:

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