Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using INDEX w/MATCH to get data from unsorted source
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,'Differ ences'!$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. |
#2
|
|||
|
|||
Hi Lynn,
Try this: =INDEX('Differences'!$A2:$F$2000,MATCH($A2,'Differ ences'!$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 "Lynn Bales" wrote in message ... 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,'Differ ences'!$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. |
#3
|
|||
|
|||
Awesome KL, thanks for the help. Worked perfectly....now on to something else
I probably won't get by myself..... :) L "KL" wrote: Hi Lynn, Try this: =INDEX('Differences'!$A2:$F$2000,MATCH($A2,'Differ ences'!$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 "Lynn Bales" wrote in message ... 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,'Differ ences'!$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. |
#4
|
|||
|
|||
No prob - thanks for your feedback.
KL "Lynn Bales" wrote in message ... Awesome KL, thanks for the help. Worked perfectly....now on to something else I probably won't get by myself..... :) L "KL" wrote: Hi Lynn, Try this: =INDEX('Differences'!$A2:$F$2000,MATCH($A2,'Differ ences'!$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 "Lynn Bales" wrote in message ... 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,'Differ ences'!$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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
How to sort/update large excel db | Excel Discussion (Misc queries) | |||
Charting data ranges that change | Charts and Charting in Excel |