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.