I have a spreadsheet where I am trying to match a person's last name and first name, and then record their corresponding title from a database. I want to match their names, which are in separate columns b/c we have several people with the same last names. I used an array formula and everything worked fine. However, I do not want to use an array formula, because other people are going to be updating this information, and they will have no idea how to work with arrays.
The formula I am now using only works some of the time. Here is an example of my spreadsheet.
Here is my database:
The formula I am now using only works some of the time. Here is an example of my spreadsheet.
| Conversion to Hourly Wagesv1.xls | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | LastName | FirstName | JOBTitle | |||
| 2 | Abraham | Basmattie | #N/A | |||
| 3 | Abramson | Richard | Richard | |||
| 4 | Adelson | Robin | #N/A | |||
| 5 | Adlerstein | Alan | #N/A | |||
| 6 | Alexander-Drayton | Georgette | LeadCorporateAgent | |||
| 7 | Anzalone | AntoinetteK. | #REF! | |||
Sheet1 | ||||||
Here is my database:
| Conversion to Hourly Wagesv1.xls | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 11 | LastName | FirstName | JOBTITLEDESCR | |||
| 12 | Abramson | Richard | CorporateAgent | |||
| 13 | Alexander-Drayton | Georgette | LeadCorporateAgent | |||
| 14 | Anzalone | AntoinetteK. | Support | |||
| 15 | Auld | SandraW. | GetThereAdministrator | |||
| 16 | Ayres | JohnDavid | CorporateAgent | |||
Sheet1 | ||||||
