View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trishames Trishames is offline
external usenet poster
 
Posts: 1
Default Vlookup with if statement

I am getting #n/a with this formula
=IF(VLOOKUP(A2,downtime,6,FALSE)0,VLOOKUP(A2,down time,6,FALSE),24) where
downtime is a range and column 6 is the value I want returned if true if
false, I want 24 and all I get is #N/A

Can anyone please help

Thank you
--
Trish McConnell