Lookup names within additional text

Closed
G - Jun 8, 2011 at 09:37 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Jun 9, 2011 at 01:01 AM
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 response

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Jun 9, 2011 at 01:01 AM
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
0