Microsoft Office Forums N/A Value in Lookup Formula

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-29-2019, 07:24 AM
NickFazer NickFazer is offline N/A Value in Lookup Formula Windows 7 64bit N/A Value in Lookup Formula Office 2003
Novice
N/A Value in Lookup Formula
 
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 N/A Value in Lookup Formula Windows 8 N/A Value in Lookup Formula Office 2016
Expert
 
Join Date: May 2017
Posts: 455
ArviLaanemets will become famous soon enoughArviLaanemets 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 N/A Value in Lookup Formula Windows 7 64bit N/A Value in Lookup Formula Office 2003
Novice
N/A Value in Lookup Formula
 
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
N/A Value in Lookup Formula 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 09:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft