Questions about Drop Downs and Tables

Hi,

I want to create a drop down table that pulls in information from a database on a different worksheet. It's been a LONG time since I last did it, so I have been looking online about how to do it. One thing the instructions mentioned was about making sure the data was in an Excel Table (article in question is here: https://support.office.com/en-gb/art...rs=en-GB&ad=GB). I'd not come across this before, so I was wondering if I should do this first. My database will hopefully be growing over time, and what I don't want to have to do is keep on changing the size of the range each time I add a new line to the table.

I've attached a workbook showing the sort of thing I'd like to do. I want to be able to call up a name and automatically pull in their age and height. What would be brilliant is if there was a way to automatically expand the range of the cells called for whenever I add a new line. Can anyone help, please?

Thanks!

Thanks for that, but I am having trouble getting it to work. I have tried copying and pasting the formulas, but I'm not getting a drop down list out of it.

I did try something else, and managed to use Data Validation to call up the list of names, and I think it is the command VLOOKUP I need to use to call up the rest of the table. However, I can't get that to work.

Got it!

I use Data Validation to do call up the names. If I make the list far longer than the names, I can keep on adding to the database and the drop down box will keep on calling it up. In this instance, I did the range from A2:A30.

For retrieving the data, I use VLOOKUP. For example, in Cell D4, I put:

=VLOOKUP(C4;Database!A2:C30;2;FALSE)

Yay!