| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find a match from range
i have two sheets with the same data, but each sheet has additional
data as well....i need to match up the 2 sheets using the matching data. so its like this.... Sheet 1 A B C D E 1 1 4 6 3 2 2 4 5 3 6 7 Sheet 2 A B C D E 1 4 5 3 6 7 2 1 4 6 3 2 so i need to take the range in sheet 2 A1:E1 and find the row that matchs it in sheet 1...... in the example, the result would be row 2...... how would i go about doing that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find the second match using the match function | Excel Worksheet Functions | |||
| Find an exact match and go to that match | Excel Discussion (Misc queries) | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
| Find closest match and return next highest number in range | Excel Discussion (Misc queries) | |||
| Use MATCH to find position of max in 2D range? | Excel Worksheet Functions | |||
![Nigel[_27_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
