| 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. |
| 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 | |||
Threaded Mode
