HI all
I have been struggling to come up with an excel formula that will look up a person's first name and last name (they are in 2 separate columns) and match both (in case there are > 2 people with the name John) and return the person's phone number.
For each client, I want to be able to look up the relationship manager's firstname and surname and return their business phone number.
i have tried to do this with nested IF statements combining VLOOKUPS but it's just not working.
I cannot combine FIrstName Last Name as the data setup i will be looking up will be large and is from a database dump extract so want to use the columns it outputs.
Any help is very much appreciated.
Many thanks
<tbody>
</tbody>
I have been struggling to come up with an excel formula that will look up a person's first name and last name (they are in 2 separate columns) and match both (in case there are > 2 people with the name John) and return the person's phone number.
For each client, I want to be able to look up the relationship manager's firstname and surname and return their business phone number.
i have tried to do this with nested IF statements combining VLOOKUPS but it's just not working.
I cannot combine FIrstName Last Name as the data setup i will be looking up will be large and is from a database dump extract so want to use the columns it outputs.
Any help is very much appreciated.
Many thanks
Company | First Name | Last Name | Position Descr | Business Phone | Business Fax | Business Mobile |
Wealth Management | Matthew | Brown | Manager | 02 9948 8012 | ||
Wealth Management | John | Smith | Sales | 02 9939 4122 | ||
Wealth Management | Matthew | Weels | Marketing | 03 0424 1222 | ||
Client Name | Relationship Manager FirstName | Relationship Manager LastName | Relationship Mger Phone | |||
Sandy | Matthew | Brown | =VLOOKUP(B13 &" " &C13, B2:E4, 4, FALSE) | |||
Lisa | John | Smith | ||||
Simon | Matthew | Weels |
<tbody>
</tbody>