=IF(VLOOKUP(...)=6,VLOOKUP(...),24)

Dave
--
Brevity is the soul of wit.


"Trishames" wrote:

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