| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP
I have two workbooks which have the same data in 5 cells in a row
across a but in cell a the name is different would anyone know how to match criteria by 5 cells being identical in a row to another workbook ? Help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
LOOKUP
Probably easier to contatenate the cells together like this:
=A1&B1&C1&D1&E1 in a helper column, then use this as the lookup or match column. Give more details of the layout of your data if you want more specific help. Hope this helps. Pete On Mar 7, 2:11*pm, wrote: I have two workbooks which have the same data in 5 cells in a row across a *but in cell a the name is different would anyone know how to match criteria by 5 cells being identical in a row to another workbook ? Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
Linear Mode
