I have a wee quandry that I'm not too sure about;
In cell A1, I have a drop-down list containing 4 names. Each of these names has a corresponding identification number, which I would like to have populated in cell A2, depending on which name is selected.
For example: John Smith's number is 745, Joe Bloggs is 520 etc. If I select John Smith from the list in A1, I want 745 to appear in A2, and so on.
Other points to note: The drop-down list may end up being up to 15 names long. All of the names and their corresponding numbers are listed in a seperate worksheet if needed.
I thought I'd be able to use an IF statement for this, but now I'm not so sure! Is there an easy way to do this? Many thanks!
Bookmarks