Could someone help me with a formula (not VBA) to lookup a value in another sheet and return the cell reference? The catch is that I don't know the row or column where the search value will be found. I've tried Find and Index, but either they don't work or I don't understand them.
I have an organization chart (see Employee Chart table below) that shows our company hierarchy. The other tab is a list of the same names, just in columns so that I can more easily analyze and compare to other sheets.
On the List worksheet, I would like a formula in Column A to look at the Chart worksheet, range A1:Z100, and tell me what cell the Employee ID is in.
<tbody>
</tbody>
Here's an example of the Employee Chart worksheet
<tbody>
</tbody>
Thanks for any suggestions!
I have an organization chart (see Employee Chart table below) that shows our company hierarchy. The other tab is a list of the same names, just in columns so that I can more easily analyze and compare to other sheets.
On the List worksheet, I would like a formula in Column A to look at the Chart worksheet, range A1:Z100, and tell me what cell the Employee ID is in.
A | B | C | |
1 | Location in Chart worksheet | Employee ID | Employee Name |
2 | B4 | 123456 | Bill |
3 | E4 | 789101 | Ted |
4 | B8 | 454545 | Rufus |
<tbody>
</tbody>
Here's an example of the Employee Chart worksheet
A | B | C | D | E | |
1 | Name | ID | Name | ID | |
2 | |||||
3 | Finance Dept | HR Department | |||
4 | Bill | 123456 | Ted | 789101 | |
5 | |||||
6 | |||||
7 | Planning Dept. | ||||
8 | Rufus | 454545 |
<tbody>
</tbody>
Thanks for any suggestions!