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!