SwimmingNathan
New Member
- Joined
- Aug 21, 2013
- Messages
- 34
Hey,
So I have a spreadsheet with two sheets, on the first is a list of contact details, including CRM ID numbers.
First sheet:
<tbody>
</tbody>
On the second sheet I have details of opportunities, the only identifiable variable on this sheet is the customer name.
I want to search the first sheet based on the name and return the ID.
Second sheet:
<tbody>
</tbody>
The formula in the second column contains a formula I'm using to check whether the names are actually in the first sheet.
I can re-configure the layout of the spreadsheet if needs be, I'm sure there's a fairly simple solution, my brain just is not playing ball.
Any help is greatly appreciated.
Cheers,
SwimmingNathan
So I have a spreadsheet with two sheets, on the first is a list of contact details, including CRM ID numbers.
First sheet:
CRM ID | Full Name |
d2f6vr61-5v5r11vdv1-d6vd6g6e <tbody></tbody> | Sonny Jim |
<tbody>
</tbody>
On the second sheet I have details of opportunities, the only identifiable variable on this sheet is the customer name.
I want to search the first sheet based on the name and return the ID.
Second sheet:
Sonny Jim | =INDEX('Customer contacts CEGX 08.08.13'!E:E, (MATCH(Opps!C4,'Customer contacts CEGX 08.08.13'!E:E,0))) | (I want to return the ID in for the name in the first column here. |
Rod Stewart | =INDEX('Customer contacts CEGX 08.08.13'!E:E, (MATCH(Opps!C4,'Customer contacts CEGX 08.08.13'!E:E,0))) | |
Helen McArthur | =INDEX('Customer contacts CEGX 08.08.13'!E:E, (MATCH(Opps!C4,'Customer contacts CEGX 08.08.13'!E:E,0))) |
<tbody>
</tbody>
The formula in the second column contains a formula I'm using to check whether the names are actually in the first sheet.
I can re-configure the layout of the spreadsheet if needs be, I'm sure there's a fairly simple solution, my brain just is not playing ball.
Any help is greatly appreciated.
Cheers,
SwimmingNathan