View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default Adding ISERROR to formula

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