Hello,
I have two spreadsheets.
One contains Application Names: Adobe Acrobat, Outlook, Zin Player, etc. 1179 Rows
The other contains Application Paths: D:/Web Content/Adobe Acrobat/manage. 3319 Rows
I'm trying to identify the application names that are listed in the first spreadsheet within the second spreadsheet.
Is there a formula to automate the search to do this?
I've tried the COUNTIF formula, but to no avail.
I don't want to have to search manually for 1179 matches in the Application Paths spreadsheet.
Any help would be much appreciated.
Thank you.
Bookmarks