Index match function

[Tip Tucci]

Sheet1
In B column I have VBA autocomplete drop down list. As soon as I choose product in B10 cell, I want that in C10 copies product code, and D10 description. Full table is in Sheet2. I need data in Sheet1.

Please help me with INDEX MATCH formula.

Sheet2

	A	B	C
1	Product name	Product code	description
2
3

<tbody>
</tbody>

 

[Scott T]

maybe

Book1
	A	B	C
1	Product Name	Product Code	Description
2	item7	it7	7th
3	item4	it4	4th
4
Sheet1

Cell Formulas
Range	Formula
B2	=IF(ISBLANK(A2),"",INDEX(Sheet2!$B$2:$B$12,MATCH(A2,Sheet2!$A$2:$A$12,0)))
B3	=IF(ISBLANK(A3),"",INDEX(Sheet2!$B$2:$B$12,MATCH(A3,Sheet2!$A$2:$A$12,0)))
B4	=IF(ISBLANK(A4),"",INDEX(Sheet2!$B$2:$B$12,MATCH(A4,Sheet2!$A$2:$A$12,0)))
C2	=IF(ISBLANK(A2),"",INDEX(Sheet2!$C$2:$C$12,MATCH(A2,Sheet2!$A$2:$A$12,0)))
C3	=IF(ISBLANK(A3),"",INDEX(Sheet2!$C$2:$C$12,MATCH(A3,Sheet2!$A$2:$A$12,0)))
C4	=IF(ISBLANK(A4),"",INDEX(Sheet2!$C$2:$C$12,MATCH(A4,Sheet2!$A$2:$A$12,0)))

Book1
	A	B	C
1	Product Name	Product Code	Description
2	item1	it1	first item
3	item2	it2	2nd item
4	item3	it3	3rd
5	item4	it4	4th
6	item5	it5	5th
7	item6	it6	6th
8	item7	it7	7th
9	item8	it8	8th
10	item9	it9	9th
11	item10	it10	10th
12	item11	it11	11th
Sheet2

 

[Tip Tucci]

Scott T, Thank you! I will try and hope it works.