Forum Discussion
How can I check to see if the 900 people appear in an Excel sheet that contains 16000 different rows
Hi can someone please help? I have two tabs of data, tab one contains 16000 rows of data and tab two contains 900 rows of data that contains the names of 900 different people from my organisation (f...
Try =MATCH(A1, Sheet1!A1:A16000,0) if you got number values as output then this name is exist on sheet1. Otherwise you will get error mean doesn't exist.
Thank you for your response Harun24HR, apologies I am a total novice in Excel.
Where do i enter this formula? sheet 1 that contains the 16000 rows or sheet 2 which contains the 900 names of people?
Where do i enter this formula? sheet 1 that contains the 16000 rows or sheet 2 which contains the 900 names of people?