Help with INDEX and MATCH or it it something else

[Sean15]

Hi:

INDEX and MATCH is not returning required value in column D. Could you help me please?

Excel 2010
	A	B	C	D	E
1	Sheet1
2	Name	Type	No sold	TL Sales	Expected value
3	Alpine	Pears	12	15,000.00	15,000.00
4	Alpine	Apples	10	15,000.00	-
5	Bata	Apples	24	12,000.00	12,000.00
6	Bata	Oranges	52	12,000.00	-
7	Catnip	Pears	45	5,000.00	5,000.00
8	Catnip	Onions	62	5,000.00	-
9
10
11
12	Sheet2
13	Names	Sales
14	Alpine	15,000.00
15	Bata	12,000.00
16	Catnip	5,000.00
Sheet1 (2)

Cell Formulas
Range	Formula
D3	=INDEX($B$14:$B$16,MATCH(A3,$A$14:$A$16,0))
D4	=INDEX($B$14:$B$16,MATCH(A4,$A$14:$A$16,0))
D5	=INDEX($B$14:$B$16,MATCH(A5,$A$14:$A$16,0))
D6	=INDEX($B$14:$B$16,MATCH(A6,$A$14:$A$16,0))
D7	=INDEX($B$14:$B$16,MATCH(A7,$A$14:$A$16,0))
D8	=INDEX($B$14:$B$16,MATCH(A8,$A$14:$A$16,0))

Thanks

Regards,

Sean

 

[Sean15]

Hi:

In post#8 "Type" appear twice. It should only appear once. My apologies.

Sheet #2 contains two columns only, "Names" and "Sales". There are no duplicate "Names" in sheet2

I am trying to bring over "Sales" from sheet2 into sheet1 so I matching by "Names" only.

Sheet1 has duplicate "Names" so I only want to show total "Sales" once on Sheet1.

"Type" does not matter at all because I am not matching by "Type"

Sorry for the confusion.


Regards,

Sean

 

[jtakw]

Then see my suggestion in Post # 10.

 

[Sean15]

Thank you very much.

Regards,

Sean

 

[jtakw]

You're welcome.