Hi - you can use match function to find row of each name
in the worksheet with the salary vs wages data. Then you
can use offset function with this result to find "salary"
or "wages". hope that helps.

John
-----Original Message-----
Hi,

I'm trying to compare data from two very large
spreadsheets.
Both contain payroll data, one with hours worked per
employee, the other showing employees as wages or salary
staff. I need to pinpoint which employees in the hours
worked spreadsheet are wages staff, and which are
salaried
as quickly and easily as possible.

Please help
.