Using INDEX w/MATCH to get data from unsorted source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to add data from one sheet to another that is unsorted. The
formula I'm using:

=INDEX('Differences'!$A2:$F$2000,MATCH($A2,'Differences'!$A$2:$A$5000),6)

So according to instructions
MATCH matches the data in $A2 to similiar data in the Differences tab column A
then Index will print whatever is in the column 6 of the differences tab.

However, what's going on is that correct data is not getting into this cell.
When I evaluated the formula, the match is not matching the correct value.
 
Hi Lynn,

Try this:

=INDEX('Differences'!$A2:$F$2000,MATCH($A2,'Differences'!$A$2:$A$5000,0),6)

you need to use the 3rd argument in the function MATCH if you want to find
exact match.


Regards,
KL
 
Awesome KL, thanks for the help. Worked perfectly....now on to something else
I probably won't get by myself..... :)

L
 
No prob - thanks for your feedback.

KL


Lynn Bales said:
Awesome KL, thanks for the help. Worked perfectly....now on to something
else
I probably won't get by myself..... :)

L
Click to expand...
 
Back
Top