Trouble with Index Match

[brennanv]

I'm having trouble getting index match to work properly if the row are out of order when I'm pulling data from sheet to another. what am I doing wrong?

[TABLE="width: 192"]
<colgroup><col style="width: 48pt;" span="4" width="64"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Items[/TD]
[TD="bgcolor: transparent"]YTD[/TD]
[TD="bgcolor: transparent"]Items[/TD]
[TD="bgcolor: transparent"]YTD[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent"]A[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]B[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent"]B[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]C[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent"]C[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]D[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"]D[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]TR[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent"]E[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]TR[/TD]
[TD="bgcolor: transparent, align: right"]20[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]E[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]


The first set of data on the left is where I'm pulling from and the data on the right is wher I want it to go. I have it formatted as V-=INDEX($B$3:$B$10,MATCH(C7,$C$3:C8,0)). However it is not pulling the rows correctly if they are out of order. in this example item E is not getting pulled over correctly. any help would be very much appreciated.

 

[gaz_chops]

Your ranges need to be the same size and I think you should be matching to A!

=INDEX($B$3:$B$10,MATCH(C7,$A$3:$A$10,0))

 

[brennanv]

Your ranges need to be the same size and I think you should be matching to A!

=INDEX($B$3:$B$10,MATCH(C7,$A$3:$A$10,0))

whenever I changed the match column it returned #N/A. Also the items im looking to pull into worksheet 2 are less than are in worksheet 1. For example, there are about 100 items in worksheet 1, but I only need about 30 of them in worksheet 2. Everything is labeled the same, but I just only need 30 or so of the 100 items.

 

[gaz_chops]

Where exactly is your data?You are matching what is in C7 to col A then returning the value from col B.

 

[brennanv]

correct that is what Im trying to do, but since the rows are in different order the numbers are mixing up. The left group of cells would be worksheet one and the right would be worksheet two. i'm trying to pull from worksheet one into worksheet two.

 

[gaz_chops]

Try=INDEX(sheet2!$B$3:$B$10,MATCH(C7,sheet2!$A$3:$A$10,0))