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?