Stumped on how to vlook up this information (or Hlookup?)

[thp510]

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.

			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

 

[Sufiyan97]

Try

Book3
	A	B	C	D	E	F	G	H	I	J
1				BBB	CCC	AAA	DCC	ACB	CDC
2	BBB	50		$50	$53	$56	$45	$87	$25
3	CCC	34		$4,133	$34	$355	$151	$135	$41
4	CDC	34		$64	$34	$21	$10	$22	$34
5	CCC	5		$3	$5	$1	$5	$3	$1
6	ACB	341		$344	$351	$353	$341	$341	$433
7	AAA	645		$35	$135	$645	$431	$444	$433
8	ACB	54		$33	$66	$87	$44	$54	$22
9
Sheet1

Cell Formulas
Range	Formula
B2:B8	B2	=INDEX($D$2:$I$8,ROWS($B$2:B2),MATCH(A2,$D$1:$I$1,0))

 

[Joe4]

Place this in cell B2 and copy down to B8:

=INDEX($C2:$H2,MATCH(A2,$C$1:$H$1,0))

 

[thp510]

Try

Book3
	A	B	C	D	E	F	G	H	I	J
1				BBB	CCC	AAA	DCC	ACB	CDC
2	BBB	50		$50	$53	$56	$45	$87	$25
3	CCC	34		$4,133	$34	$355	$151	$135	$41
4	CDC	34		$64	$34	$21	$10	$22	$34
5	CCC	5		$3	$5	$1	$5	$3	$1
6	ACB	341		$344	$351	$353	$341	$341	$433
7	AAA	645		$35	$135	$645	$431	$444	$433
8	ACB	54		$33	$66	$87	$44	$54	$22
9
Sheet1

Cell Formulas
Range	Formula
B2:B8	B2	=INDEX($D$2:$I$8,ROWS($B$2:B2),MATCH(A2,$D$1:$I$1,0))

Amazing! Thank you it worked.

 

[Sufiyan97]

You're welcome.
Glad we could help.

 

[rabsofty]

=VLOOKUP(A2,A1:I8,MATCH(A2,$A$1:$I$1,0),FALSE)

try this in column B