Question asked by user @ Excel forum:-
I have 2 workbooks. In workbook (1), I have a column with a few thousand store names. In workbook (2), I have a column with a few hundred store names. The store names are not identical but have the following unique words/numbers: ABC123 etc. I want to identify if a store in workbook (2) exists in workbook (1). I have attached a sample file.
In Workbook 2, we have 2 columns, in Which column A contains only series number and in Column B we will get the whole product name through series number, which is common in both data.
To return the whole product number in workbook 2 use below given formula:-
To put the “Conditional Formatting” follow below given steps:-
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.