I have a workbook which hold two spreadsheets one is a list of work and one is a contact list, I need to be able to show if the work was done by a member of staff or by an external consultant.
I have created a column (column C) in the first sheet and I want to be able cross check with the second spreadsheet and show in column C the words STAFF or CONSULTANT.
Bookmarks