#1
|
|||
|
|||
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!!!!!! |
#2
|
|||
|
|||
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))) |
#3
|
||||
|
||||
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 |
#4
|
|||
|
|||
Well neither one of these works
|
#5
|
|||
|
|||
Never mind ...pecoflyer thank you it worked!!!!success!!!!:d
|
#6
|
||||
|
||||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Vlookup Help | jimboslice | Excel | 3 | 09-05-2013 09:42 AM |
IF and VLOOKUP | SBMC | Excel | 1 | 11-07-2012 10:24 AM |
Vlookup | Karen615 | Excel | 4 | 09-12-2011 02:30 PM |
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 |