Excel 2007 : Drop down box

**needhelp!** · 08-13-2011, 06:20 AM

Hi, I've been creating a spreadsheet which contains a user form for employee details, which when you save it enters it in to a table on the same worksheet. I now want to be able to have a drop down box on a separate worksheet, where the first and last name are displayed. Then when the user clicks the name the rest of their details are displayed below. Any ideas?

I thought maybe I could use a VLOOKUP, but I can't get it to work

Thanks x

**dominicb** · 08-13-2011, 07:31 AM

Good morning needhelp!

...and welcome to the forum!

What you want to do is certainly possible, but you need to set your data sheet up correctly. I would suggest the names going down in column 1 and the employment details, DoB, department etc going across.

For the drop down box, try experimenting with Data Validation (Data > Data Tools) : the bit you are interested in is to allow a list. You can link this to a cell range. This is the cell your VLOOKUP formula will look at, and use as a comparator.

Once you've got the basics set up post back with any problems.

HTH

DominicB

**needhelp!** · 08-13-2011, 09:13 AM

Hi thanks for the reply

I've managed to use this code in every cell but changing the column number for each field, =VLOOKUP(B8, 'Add Employee'!A11:X14,2,TRUE), but I can't seem use a drop down box as a lookup value, if more than one cell is using it as a lookup value, is there a way round this? Also the cell reference needs to be A11:X200 but everytime I enter this the value in the field automatically goes to 0, I think this may be because there is no data past X14 yet?

Thanks