LinkBack URL
About LinkBacks
Reply With QuoteWhat is the lookup value?
This is a discussion on If IS ERROR within the Excel Questions forums, part of the Question Forums category; How do I add a IF Is ERROR to the formula below? =IF(H276="",VLOOKUP(AA:AA,'STAT Table'!A:G,7,FALSE),H276) If the VLookup is not found ...
If IS ERROR
How do I add a IF Is ERROR to the formula below?
=IF(H276="",VLOOKUP(AA:AA,'STAT Table'!A:G,7,FALSE),H276)
If the VLookup is not found it returns a #N/A. I want it to return a '0' if it is not found.
What is the lookup value?
Some more questions... Why are you using AA:AA as the 1st argument of your VLOOKUP? Why do you need ISERROR?
is error
Hi,
with the free addin of ASAP, see www.asap-utilities.com
you do not have to worry anymore.
See, under range, custom formula error message
I am sure this free addin solves a lot of problems for you
Jack
=IF(ISERROR(IF(H276="",VLOOKUP(AA:AA,'STAT Table'!A:G,7,FALSE),H276) ,"",IF(H276="",VLOOKUP(AA:AA,'STAT Table'!A:G,7,FALSE),H276) )
In this case the cell would show blank("") when your formula gives an error result.
I hope this is what you needed.
Posting Permissions
Bookmarks