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 |