I need help creating a formula in Excel 2010.
What I want to be able to do is:
When I choose a name from a dropdown-list in a random cell in one column, I want that name to be coupled up with that name's employee number etc. So when one employee opens this shared document, he/her will be able to put in his/her number in a (random) cell adjacent to his/hers name, and the third cell will then automatically show their signature (their name in a different colour etc.)
This code must work in many cells, in many different sheets. There also needs to be one sheet with all the names and numbers in it, that I can hide.
Here's what I have tried:
The names in Sheet 1, (Module 01) is names that is selected using a dropdown list using a range in sheet 2 (Instructors).
When I choose "Tom" from the dropdown-list and enter his code 222 in the adjacent cell his signature comes up with this code. When I enter "Hans" and his code in adjacent cell his signature comes up. But I can't get any further. I want to be able to chose whoever from the dropdown-list, write that persons number and have their signature appear.
If the wrong number is entered, there will be shown a blank cell.