| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Matching - Bring the entire row.
Hi,
I have rows of data with Column A being the key identifier in worksheets SPR1 and SPR2 inside a work book. Reading one of the threads below, I am using the following formula in SPR3 (3rd worksheet in the same workbook) to identify a match between SPR2 and SPR1 from Column A in both columns: =IF(NOT(ISNUMBER(MATCH(spr2!A1,spr1!A:A,0))),"",IN DEX(spr1!A:A,MATCH(spr2!A1,spr1!A:A,0))) Is there any way to bring the entire Row of data in SPR1 and SPR2 (assuming they are the same) instead of just column A into SPR3? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What function-bring me the info in the next column-same row? | Excel Worksheet Functions | |||
| Bring a code from a cell to a column | Excel Worksheet Functions | |||
| Return position for each matching value in entire workbook? | Excel Worksheet Functions | |||
| Search for data in a column bring all related items in other colum | New Users to Excel | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
Threaded Mode
