Forum Discussion
Solved
PULLING ONE OF FOUR PRICES BASED ON A SPECIFIC TEXT IN A ROW CORESSEPONDING TO 4 CELLS
Sorry for the capslock, OK, so I have a list of names that have an "x" in either the well, call, premium or ultra columns of a worksheet. is there a way to pull which column the "x" is located in...
- ITS THE FORMULA XLOOKUP!!!!!!!!!!!!!
Let's say you have a sheet called PriceList with data like this:
Another sheet looks like this:
The formula in F2 is
=INDEX(PriceList!$B$2:$E$200, MATCH(A2, PriceList!$A$2:$A$200, 0), MATCH("x", B2:E2, 0))
I like that,
But this is what it looks like on my end. I need to pull the price marked be the "x" and have that populate on another sheet listed as each individual vodka ect.
The House Spirits List VODKA House 10$ Call $12 Premium 16$ Ultra-Premium $18+ BELVEDERE X GREY GOOSE X GREY GOOSE L'ORANGE X KETEL ONE X MIP X STOLI X STOLI BLUEBERRY X STOLI CITRON X STOLI ELITE X STOLI VANILLA X TITO'S X - ITS THE FORMULA XLOOKUP!!!!!!!!!!!!!