VLOOKUP: Wont return value
Can you just explain a bit about your data.
If this post helps click Yes
---------------
Jacob Skaria
"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
|