LOOKUP

[jackcwood]

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

 

[Pete_UK]

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