ExcelBanter - Vlookup with if statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Vlookup with if statement (https://www.excelbanter.com/excel-discussion-misc-queries/120598-re-vlookup-if-statement.html)

Dave F

Vlookup with if statement

=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

All times are GMT +1. The time now is 01:32 PM.