Need Drop down selection that causes more than one cell to change

[amzcom]

I need to edit a database file using an excel sheet. So I have for example 3 fields in the database. The first field is the primary key which is a unique number) and the other filed is called Name and third field is called Address .

My drop down menu should contain the list of all primary keys that are in the database. When i select any number then I should be able to see the Number and Address in the cells next to this drop down menu. Is this possible? Can anyone please help. THANKS!!

AMZ

[JBeaucaire]

In cell 1 (A1?) create a Data Validation drop box. If the data is on another sheet, create a named range of all the primary keys, then use that name in the validation list.

To get the matching Name (B1?) to appear and the matching address (C1?), a simple VLOOKUP should work at that point.

You can read up on

1) Name Ranges
2) Data Validation Drop Box
3) VLOOKUP

by pressing F1 in Excel.

If it's too much, then post a sample workbook showing the sample data and your desired results, point out where the results came from if not obvious in your sample data.

Then click GO ADVANCED and use the paperclip icon to post up your workbook.

[amzcom]

Thanks for your post. Data Validation and VLOOKUP did the trick!

Thanks again.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save