LOOKUP

  • Thread starter Thread starter jackcwood
  • Start date Start date
J

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
 
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
 
Back
Top