Using value in A1 to populate a value in A2

**Rayneill** · 01-09-2013, 02:26 AM

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!

**vlady** · 01-09-2013, 02:32 AM

you could try vlookup

**Rayneill** · 01-09-2013, 03:21 AM

Ahhh, didn't know about that one! Solved my issue perfectly thank you.

**vlady** · 01-09-2013, 03:27 AM

Welcome,
regards,
vladimir

**Rayneill** · 01-09-2013, 07:54 PM

Ok, so its not as solved as I first thought. The VLOOKUP works fine, until the auto-sorting macro I also have gets a hold of things (active when the worksheet is closed). After the sort has occurred, the VLOOKUP no longer works in the rows that have been sorted. Is there a way to prevent the formula going away once the sort has happened?