Hello people.
I have watched YouTube read the IFERROR formula information but cannot seem to get the following to work.
I have a lookup formula as you can see, but when the cell is blank it keeps returning the Error.
Help much appreciated.
Rich
iMac 21.5″, macOS 10.13
Hi Rich,
You've not told IFERROR what to do if the formula returns an error.
Here's the syntax for IFERROR:
IFERROR(any-expression, if-error)
In your case, the expression is the VLOOKUP formula:
VLOOKUP(AF$1,LOG::$A:$C,3,1)
Applying the syntax, your formula would be:
IFERROR(VLOOKUP(AF$1,LOG::$A:$C,3,1),"do this")
with "do this" replaced by the result you want if VLOOKUP throws an error.
Regards,
Barry
Hi Rich,
You've not told IFERROR what to do if the formula returns an error.
Here's the syntax for IFERROR:
IFERROR(any-expression, if-error)
In your case, the expression is the VLOOKUP formula:
VLOOKUP(AF$1,LOG::$A:$C,3,1)
Applying the syntax, your formula would be:
IFERROR(VLOOKUP(AF$1,LOG::$A:$C,3,1),"do this")
with "do this" replaced by the result you want if VLOOKUP throws an error.
Regards,
Barry
Thank you
You're welcome.
Thanks for the green checkmark.
Regards,
Barry
If Error issue.
