Forum Discussion
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 and populate the price of that cell?
for clarification.
columns B, C, D, E correspond to a specific price. Each spirit is listed in column A. On a different sheet I want to populate the price for each spirit which would be designated by the "x" in either column B-E.
- ITS THE FORMULA XLOOKUP!!!!!!!!!!!!!
3 Replies
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!!!!!!!!!!!!!
