I'm trying to find the price of a particular item based on the product selected in Column A in that specific row. As an example, on cell A2, the product BBB was selected. If you look across row 2, BBB is set at $50. Therefore, on cell B2, I have $50. For Cell A3, the product CCC was selected. On row 3, CCC is worth $34. Therefore cells B3 has $34 in it. This goes on and on for about 200+ rows. Can anyone help me with what function I can put in column B so I can drag that function all the way down that column? Thanks.
Here's are the prices again.
Here's are the prices again.
BBB | CCC | AAA | DCC | ACB | CDC | |||
BBB | $50 | $ 50 | $ 53 | $ 56 | $ 45 | $ 87 | $ 25 | |
CCC | $34 | $ 4,133 | $ 34 | $ 355 | $ 151 | $ 135 | $ 41 | |
CDC | $34 | $ 64 | $ 34 | $ 21 | $ 10 | $ 22 | $ 34 | |
CCC | $5 | $ 3 | $ 5 | $ 1 | $ 5 | $ 3 | $ 1 | |
ACB | $341 | $ 344 | $ 351 | $ 353 | $ 341 | $ 341 | $ 433 | |
AAA | $645 | $ 35 | $ 135 | $ 645 | $ 431 | $ 444 | $ 433 | |
ACB | $54 | $ 33 | $ 66 | $ 87 | $ 44 | $ 54 | $ 22 |