Cell matching

**Jamine90** · 06-03-2014, 10:05 PM

I am having 2 worksheet and each of them having name of student.Sheet1 has student name and roll number,sheet2 has name only.

I want to match sheet1 student name with sheet2 student name.Names in both the sheets are not exactly matching.I want to match names on the basis of first name(first word) and last name (last word) or firstname or last name.For example

Sheet1 Name = Nirmali Steve Joe , Sheet1 Roll No= 1572
Sheet2 Name - Nirmali Joe

I should get result Nirmali Joe, 1572

I appreciate your help

**Miroslav R.** · 06-04-2014, 01:10 AM

Hi there,
please provide sample workbook with possible scenarios.

**FDibbins** · 06-04-2014, 01:22 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**Jamine90** · 06-04-2014, 06:42 AM

Attached sheet will help you to understand what I am looking for.

Thanks in advance.

**ManNav** · 06-04-2014, 02:46 AM

I think this problem is like that of mine. But I don't have the solution

Plz find attached dummy data.
Sheet1: Company Name and Details
Sheet2: Company Name

I need to partially compare Company Name in sheet2 with Company Name in sheet1 and output should be Company Name of sheet2)+ (Details)

E.g. Sheet1 Company Name: Spanish MountainGold
Details : Preciousmetals

Sheet2 Company Name: 1) Spanish Mountain 2) Spanish Inc

Output should be: Spanish Mountain Preciousmetals
Spanish Inc Preciousmetals