Lookup names within additional text

Closed
Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hi,

I got full names in one spreadsheet (A) and another speadsheet (B) with full names plus other text in the same cell.

How can I run a lookup to determine the cells in spreadsheet B which contain the names from spreadsheet A.

Thanks,
G

1 reply

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Could you please upload a sample EXCEL file WITH sample data on some shared site like https://authentification.site
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note: your data need not be to be real data but a good representative of how data looks like