Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
H H is offline
external usenet poster
 
Posts: 57
Default Vlookup

Hi :) I'm using this lookup to find a date from another tab but I would like
it to leave it blank if there is not a date instead of filling in 1/0/1900?
Does anyone know a way to fix this? Thank you!!

=VLOOKUP(B4,'Data'!A2:F7863,3,FALSE)