Typically, Excel returns an N/A on a VLOOKUP when it cannot find the value in
your A2 cell in the downtime chart. Is the value you are trying to lookup in
cell A2 contained within the first column of the downtime detail?

"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