Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-29-2019, 07:24 AM
NickFazer NickFazer is offline Windows 7 64bit Office 2003
Novice
 
Join Date: Sep 2018
Posts: 8
NickFazer is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 03-29-2019, 07:33 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 426
ArviLaanemets will become famous soon enough
Default

As you use Office2003, IFERROR() is not an option. So you'll have to use
Code:
= IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))
Reply With Quote
  #3  
Old 04-02-2019, 04:22 AM
NickFazer NickFazer is offline Windows 7 64bit Office 2003
Novice
 
Join Date: Sep 2018
Posts: 8
NickFazer is on a distinguished road
Default

Many Thanks


Did the job.
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 08:49 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft