Hi

With your name in A2, you could use something like this:
=COUNTIF(Sheet2!K2:K10000,A2)0

Andy.

"Greenback" wrote in message
...
I have two spreadsheets each with over 5 thousand rows of data. on each
spreadsheet, column K is personnel numbers. What I want to know, is can I
create formulas in workbook 1 which would show if the personnel numbers in
workbook 1 appear in workbook 2 (column k), rather than having to search
each
personnel number manually.