OkampoVictory
New Member
- Joined
- Jan 22, 2018
- Messages
- 6
Hello Everyone,
I am hoping to populate a cell in a worksheet using Vlookup and a lookup value. The lookup value is a First and a Last Name (e.g. Serena Williams). The table array is on a separate worksheet containing the staff details for all the staff in this company. However, the first and last name are on two separate columns (e.g. B1: Williams C1:Serena). The Vlookup formula I entered was not working. I have attached the example below:
Worksheet 1:
<colgroup><col span="2"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Ideally, the Vlookup formula will return the rank based on part of the name present in worksheet 1.
Many thanks for your help!
Victory
I am hoping to populate a cell in a worksheet using Vlookup and a lookup value. The lookup value is a First and a Last Name (e.g. Serena Williams). The table array is on a separate worksheet containing the staff details for all the staff in this company. However, the first and last name are on two separate columns (e.g. B1: Williams C1:Serena). The Vlookup formula I entered was not working. I have attached the example below:
Worksheet 1:
<tbody> </tbody> Worksheet 2 | |||||
<colgroup><col span="2"></colgroup><tbody>
</tbody>
Surname | Forename | Position | Reporting Unit | Joining Date | Grade | Rank |
Williams | Serena | Manager | Finance | 12/12/2012 | B | Senior Manager |
<tbody>
</tbody>
Ideally, the Vlookup formula will return the rank based on part of the name present in worksheet 1.
Many thanks for your help!
Victory