darren_ireland
New Member
- Joined
- Sep 11, 2019
- Messages
- 3
Hi there,
Sorry to bother you but I was wondering if any Excel experts could give some guidance on a VLookup question?
I am trying to look-up two combined records. I have a sheet with Entity 1, Entity 2, Entity 3 as columns, then as rows (headers) I have departments (Accounts, HR, Admin). I want to be be able to have a drop down in a preview sheet with the entity and department and then for Excel to lookup and populate the person in each dept?
This is what I am trying to achieve (below) - in my overview sheet if I have "Entity A" with "Admin" I would like to see that "Jane Bloggs" is the contact - similarly if I had "Entity A" with "Accounts" it would show "Joe Bloggs"
I have the department and entity as drop down to assist with the lookup command. I tried unsuccessfully tried to use the concatenate formula but it just got very messy and didn't work.
Thanks a million for your time reading this!!
Darren.
<colgroup><col width="87" span="4" style="width: 65pt;"></colgroup><tbody>
</tbody>
Sorry to bother you but I was wondering if any Excel experts could give some guidance on a VLookup question?
I am trying to look-up two combined records. I have a sheet with Entity 1, Entity 2, Entity 3 as columns, then as rows (headers) I have departments (Accounts, HR, Admin). I want to be be able to have a drop down in a preview sheet with the entity and department and then for Excel to lookup and populate the person in each dept?
This is what I am trying to achieve (below) - in my overview sheet if I have "Entity A" with "Admin" I would like to see that "Jane Bloggs" is the contact - similarly if I had "Entity A" with "Accounts" it would show "Joe Bloggs"
I have the department and entity as drop down to assist with the lookup command. I tried unsuccessfully tried to use the concatenate formula but it just got very messy and didn't work.
Thanks a million for your time reading this!!
Darren.
Accounts | HR | Admin | |
Entity A | Joe Bloggs | Jane Bloggs | |
Entity B | |||
Entity C | |||
Vlookup 1 | Vlookup 2 | Result (=Entity & Admin) | |
Entity | Department | Jane Bloggs |
<colgroup><col width="87" span="4" style="width: 65pt;"></colgroup><tbody>
</tbody>