Help with INDEX and MATCH or it it something else

Sean15

Well-known Member
Joined
Jun 25, 2005
Messages
698
Office Version
  1. 2010
Platform
  1. Windows
Hi:

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


Excel 2010
ABCDE
1Sheet1
2NameTypeNo soldTL SalesExpected value
3AlpinePears1215,000.0015,000.00
4AlpineApples1015,000.00-
5BataApples2412,000.0012,000.00
6BataOranges5212,000.00-
7CatnipPears455,000.005,000.00
8CatnipOnions625,000.00-
9
10
11
12Sheet2
13NamesSales
14Alpine15,000.00
15Bata12,000.00
16Catnip5,000.00
Sheet1 (2)
Cell Formulas
RangeFormula
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
 
Last edited:
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
 
Upvote 0

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Then see my suggestion in Post # 10.
 
Upvote 0

Forum statistics

Threads
1,213,550
Messages
6,114,265
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top