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

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