| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match and display
example;
sheet1;A2:A10 and sheet2;A2:A10 contain the same unique values sheet1;B2:B10 contains no unique values sheet2:B1 contains a value I need a formula that will return a match to correspond with sheet2;B1 and sheet1;B2:B10 and if found return it in sheet2;B2:B10 Bearing in mind that sheet1;A2:A10 and sheet2;A2:A10 must also match Thank you if you can be of help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display first or second match instead of #REF in INDEX ROW formula | Excel Worksheet Functions | |||
| Match Function And Display Row Number | Excel Worksheet Functions | |||
| Cross match data in Col A v/s Col B and display match in Col 3 | Excel Discussion (Misc queries) | |||
| Print out doesnt match display | Excel Discussion (Misc queries) | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
Threaded Mode
