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?

One way:
see attached workbook.
formula in column C of sheet "LookUp"

Attached Files

LookUp.xlsx (9.5 KB, 12 views)

If that works for the OP, it can be shortened to...

=VLOOKUP(A2,SupplierTable!$A$2:$C$6,IF(B2="a",2,3) ,0)

nice and concise @jeffreybrown

Moved to non-VBA forum. Please post in the right forum in the future. Thx

__________________
Using O365 v2503 - 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