quickhappy
Board Regular
- Joined
- Dec 21, 2013
- Messages
- 65
Hi All,
I need help with a formula. I have one workbook with two sheets I'm using. The first sheet has first and last names in two columns. I know I could combine them but I have to often download and this is how the sheet comes default so trying to limit the amount of manipulating I would have to do.
Ok so I need sheet 1 to look on sheet 2 and match first and last names then return a value that is one sheet 2. Example of both sheets below.
SHEET 1 BELOW. TECH NUMBER IS THE COLUMN WHERE I WANT THE FORMULA AND RESULT.
<colgroup><col><col span="3"><col span="2"></colgroup><tbody>
</tbody>
SHEET 2 LOOKS LIKE THIS.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
TO RECAP I JUST WANT A FORMULA THAT LOOKS AT FIRST NAMES ON SHEET AND SHEET 2, THEN LOOK AT LAST NAMES ON SHEET 1 AND 2 AND IF MATCH THEN GIVE ME THE "TECH NUMBER" AS THE RESULT.
I need help with a formula. I have one workbook with two sheets I'm using. The first sheet has first and last names in two columns. I know I could combine them but I have to often download and this is how the sheet comes default so trying to limit the amount of manipulating I would have to do.
Ok so I need sheet 1 to look on sheet 2 and match first and last names then return a value that is one sheet 2. Example of both sheets below.
SHEET 1 BELOW. TECH NUMBER IS THE COLUMN WHERE I WANT THE FORMULA AND RESULT.
| Market | FIRST NAME | LAST NAME | TECH NUMBER | CSAT Score | NPS Score |
| Flagstaff | ASA | JONES | 95.96 | 100.00% | |
| Flagstaff | JOHN | HUNSBERGER | 95.13 | 100.00% | |
| Flagstaff | JOSHUA | VOSBERG | 99.94 | 100.00% | |
| Flagstaff | RANDALL | SANDEFER | 96.31 | 94.44% | |
| Flagstaff | RONALD | PACK | 100.00 | 100.00% | |
| Flagstaff | WILLIAM | CRISE | 94.20 | 77.27% | |
| Flagstaff | KEN | AUBART | 95.40 | 86.96% |
<colgroup><col><col span="3"><col span="2"></colgroup><tbody>
</tbody>
SHEET 2 LOOKS LIKE THIS.
| Last Name | Tech Number | Market | First Name |
| DYNAMIC | DVSS000167 | Phoenix West | JOHN |
| TECH | DVSS000168 | Phoenix West | DYNAMIC |
| ADMIN | DVSS000171 | Phoenix West | DYNAMIC |
| SOPR | DVCA852130 | San Diego, CA | ROBERT |
| WARTENBEE | DVAZ838696 | Phoenix East | SHANE |
| SMITH | DVAZ811608 | Phoenix West | JASON |
| MURRIN | DVAZ865116 | Phoenix West | JOSH |
| STRANIK | DVSS000183 | Phoenix East | WYATT |
| WALKUP | DVAZ838669 | Phoenix East | ANTHONY |
| GADAEV | DVAZ838689 | Phoenix East | NERIK |
| SARI TERZI | DVAZ838618 | Phoenix East | SERGHEI |
| REIDHEAD | DVAZ863100 | Phoenix East | AARON |
| PAGELS | DVAZ863105 | Phoenix East | JASON |
| COOK | DVAZ838665 | Phoenix East | RYAN |
| DARWISH | DVAZ863107 | Phoenix East | TONY |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
TO RECAP I JUST WANT A FORMULA THAT LOOKS AT FIRST NAMES ON SHEET AND SHEET 2, THEN LOOK AT LAST NAMES ON SHEET 1 AND 2 AND IF MATCH THEN GIVE ME THE "TECH NUMBER" AS THE RESULT.
