Is there a way to create a iferror equivalent function in excel 2003? THis way I wouldnt have to create double vlookups to eliminate the N/A in my worksheets. Wouldnt this result in worksheets calculating faster?
ADVERTISEMENT
If a formula with VLOOKUP is expected, to return a number, try:
=LOOKUP(9.99999999999999E+307,CHOOSE({1,2},0,VLOOKUP(...)))
This scheme can be used with any formula expression expected to return a number.
Note that this can be made to return a blank. However, the formula cell can be custom formatted as e.g.,
[=0]"";General
A similar scheme is possible with text-returning expression, including one with VLOOKUP like in:
=LOOKUP(9.99999999999999E+307,CHOOSE({1,2},"",VLOOKUP(...)))
ADVERTISEMENT
=if(iserror([COLOR=#333333]VLOOKUP(A:A,'Initial Measurement Period'!$A$2:$J$330,9,FALSE)),"-",[/COLOR]([COLOR=#333333]VLOOKUP(A:A,'Initial Measurement Period'!$A$2:$J$330,9,FALSE)[/COLOR][COLOR=#333333]))[/COLOR]
Try:
Code:=if(iserror([COLOR=#333333]VLOOKUP(A:A,'Initial Measurement Period'!$A$2:$J$330,9,FALSE)),"-",[/COLOR]([COLOR=#333333]VLOOKUP(A:A,'Initial Measurement Period'!$A$2:$J$330,9,FALSE)[/COLOR][COLOR=#333333]))[/COLOR]