#1
|
|||
|
|||
N/A Value in Lookup Formula
Hello
I have the below formula that looks up a value for glucose in a recipe from a different sheet, it works fine until the recipe I am looking up doesn't have glucose in and an error N/A value is returned, I need this formula to return a value of 0 or blank if there is no glucose in the recipe. =IF($E8>0,VLOOKUP($E8,'F:\01 Logistics\SUGAR\[LookupGlucose.xls]LookupGlucose'!$A$1:$D$299,4,FALSE),0) Thanks Nick |
#2
|
|||
|
|||
As you use Office2003, IFERROR() is not an option. So you'll have to use
Code:
= IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...)) |
#3
|
|||
|
|||
Many Thanks
Did the job. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to update lastname with the help of V-Lookup formula? | Mangesh1212 | Excel | 6 | 12-05-2018 02:15 AM |
Filter or Lookup Formula to Organize Keywords | MKTGCLOUD | Excel | 8 | 11-28-2018 07:35 PM |
Need help with lookup formula | tristanlau | Excel | 1 | 08-14-2017 07:16 AM |
Formula help please (lookup across multiple sheets) | froggybsb03 | Excel | 2 | 03-16-2017 02:16 AM |
LOOKUP - Complex lookup with 2 lookups in 1 cell | sglandon | Excel | 6 | 05-05-2016 09:44 AM |