#1
|
|||
|
|||
Vlook up multiple sequence
I need a vlook up that will search one particular column if B1 says "a" but if B1 says "b" I need the data from a Seperate colum.
I have two glass supplies to quote off. With lists next to yeah other with the varying price for the same product. So if glass supplies A is false . Then I need it to ignore that vlookup and run a second vlookup which will pull data from a different column but put the data in the same.place as the first vlookup Now that I've typed that it seems very confusing.. I promise it's not 😉 can anyone help? |
#2
|
|||
|
|||
One way:
Code:
=IF(B2="a",VLOOKUP(A2,SupplierTable!$A$2:$C$6,2,0),VLOOKUP(A2,SupplierTable!$A$2:$C$6,3,0)) formula in column C of sheet "LookUp" |
#3
|
|||
|
|||
If that works for the OP, it can be shortened to...
=VLOOKUP(A2,SupplierTable!$A$2:$C$6,IF(B2="a",2,3) ,0) |
#4
|
|||
|
|||
nice and concise @jeffreybrown
|
#5
|
||||
|
||||
Moved to non-VBA forum. Please post in the right forum in the future. Thx
__________________
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 |
Sequence problem | Pecoflyer | Excel | 2 | 01-10-2017 09:34 AM |
Problem with correcting an index sequence | John Witmer | Word | 5 | 05-13-2015 03:52 AM |
VLook up search | Tralee6 | Excel | 4 | 08-07-2014 05:20 AM |
Automatic numbering in captions out of sequence | Savager | Word | 3 | 05-25-2012 07:22 AM |
Excel sheet Sequence Number | belloffice | Excel | 1 | 02-25-2010 02:41 PM |