R
rebecca
I need to compare employee information between 2 lists and spit out
mismatches.
So, for instance, I have a spreadsheet with a column of employee IDs.
The second column is the employee department numbers. We know the
information on this spreadsheet is accurate.
There's a second spreadsheet with the same columns, however we need to
check this spreadsheet against the first because we aren't sure it's
correct.
So I need a function that will look at cell A1 in the first
spreadsheet, find the corresponding row in the second spreadsheet and
compare the corresponding department number values to see if they're
the same.
I think this is a combination of VLOOKUP and IF functions, I just
can't figure out how to refer to the row numbers.
Any ideas?
Thanks
Rebecca
mismatches.
So, for instance, I have a spreadsheet with a column of employee IDs.
The second column is the employee department numbers. We know the
information on this spreadsheet is accurate.
There's a second spreadsheet with the same columns, however we need to
check this spreadsheet against the first because we aren't sure it's
correct.
So I need a function that will look at cell A1 in the first
spreadsheet, find the corresponding row in the second spreadsheet and
compare the corresponding department number values to see if they're
the same.
I think this is a combination of VLOOKUP and IF functions, I just
can't figure out how to refer to the row numbers.
Any ideas?
Thanks
Rebecca