Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have this formula in a cell, and correctly returns #N/A where it
does not find the data the formula looks for. Have tried ISERROR, ISNA, and ISERR to return a blank cell instead of the #N/A. Excel still doesn't like the formula. How to add a statement returning a blank? =IF(R13=1,VLOOKUP(D13,'LABR A'!$B$3:$D $327,3,FALSE),IF(R13=2,VLOOKUP(D13,'LABR B'!$B$3:$D $327,3,FALSE),IF(R13=3,VLOOKUP(D13,'LABR C'!$B$3:$D $327,3,FALSE),IF(R13=4,VLOOKUP(D13,'LABR D'!$B$3:$D $327,3,FALSE),IF(R13=5,VLOOKUP(D13,'LABR E'!$B$3:$D$327,3,FALSE)))))) This formula works well, b t w. Thanks for what I thought was a no- brainer. Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using iserror in formula | Excel Discussion (Misc queries) | |||
Using ISERROR to Solve #DIV/0 in a formula | Excel Worksheet Functions | |||
Int Iserror Len Mid Find formula | Excel Worksheet Functions | |||
ISERROR | Excel Worksheet Functions | |||
iserror | Excel Discussion (Misc queries) |