| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup with if statement
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement with VLookup | Excel Worksheet Functions | |||
| Nested IF statement with VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup 'And' statement | Excel Discussion (Misc queries) | |||
| Vlookup or If statement Help | Excel Worksheet Functions | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Hybrid Mode
