View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mind_killer mind_killer is offline
external usenet poster
 
Posts: 2
Default VLOOKUP: Wont return value

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