Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2013, 08:35 PM
CSTEIGER CSTEIGER is offline Using IF and VLOOKUP Windows Vista Using IF and VLOOKUP Office 2010 32bit
Novice
Using IF and VLOOKUP
 
Join Date: Nov 2013
Posts: 6
CSTEIGER is on a distinguished road
Default Using IF and VLOOKUP


I can not seem to figure out how to use the IF function with the Vlookup. I need to have cell c17 display a blank cell if cell b15 is blank and if cell b15 contains a wrong shipping option I need it to say invalid shipping option. I have it to where it says invalid shipping option but cannot get to be blank.PLEASE HELP!!!!!!
Attached Files
File Type: xlsx Steiger,Cristi-PC Modem.xlsx (31.6 KB, 21 views)
Reply With Quote
  #2  
Old 11-20-2013, 12:35 AM
excelledsoftware excelledsoftware is offline Using IF and VLOOKUP Windows 7 64bit Using IF and VLOOKUP Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Have you tried the If(iserror formula like so
Code:
=IF(ISERROR(VLOOKUP(B5,'Product List'!$A$8:$D$119,2,FALSE)),"Product ID Not Found",(VLOOKUP(B5,'Product List'!$A$8:$D$119,2,FALSE)))
Reply With Quote
  #3  
Old 11-20-2013, 01:48 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Using IF and VLOOKUP Windows 7 64bit Using IF and VLOOKUP Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps
Code:
=IF(B15="","",IFERROR(VLOOKUP(B5,'Product List'!$D$40,$E$42,2,FALSE),"Invalid shipping option"))
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 11-20-2013, 08:59 PM
CSTEIGER CSTEIGER is offline Using IF and VLOOKUP Windows Vista Using IF and VLOOKUP Office 2010 32bit
Novice
Using IF and VLOOKUP
 
Join Date: Nov 2013
Posts: 6
CSTEIGER is on a distinguished road
Default

Well neither one of these works
Reply With Quote
  #5  
Old 11-20-2013, 09:13 PM
CSTEIGER CSTEIGER is offline Using IF and VLOOKUP Windows Vista Using IF and VLOOKUP Office 2010 32bit
Novice
Using IF and VLOOKUP
 
Join Date: Nov 2013
Posts: 6
CSTEIGER is on a distinguished road
Default

Never mind ...pecoflyer thank you it worked!!!!success!!!!:d
Reply With Quote
  #6  
Old 11-21-2013, 01:36 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Using IF and VLOOKUP Windows 7 64bit Using IF and VLOOKUP Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

You're welcome

(BTW when a proposed solution does not work, it's easier to help you further if you explain WHAT does not work )
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup Help jimboslice Excel 3 09-05-2013 09:42 AM
Using IF and VLOOKUP IF and VLOOKUP SBMC Excel 1 11-07-2012 10:24 AM
Vlookup Karen615 Excel 4 09-12-2011 02:30 PM
Using IF and VLOOKUP Can i do this with a VLookup? foodstudent Excel 1 01-21-2011 12:34 AM
Using IF & VLOOKUP together junction Excel 7 11-18-2010 05:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:00 AM.


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