Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Drop down lists

excel training courses - Drop down lists

ResolvedVersion Standard

Fri 13 Jul 2007, 12:52 Delegate Ellen said...

Ellen has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Drop down lists

When you have created a drop down list, how do you get a field of cells to automatically change to match the name selected. EG selected a person from the list and their address automatically fill in for the rest of the fields for that person that you have set up?

Thanks

Fri 13 Jul 2007, 12:56 Trainer Richard said...

RE: drop down lists

You would need to have 2 parts to that solution.

1. You must have a list of names, with addresses to lookup

2. Then use Vlookup to match the name selected, and populate each part of the address

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

View all Excel hints and tips

excel training courses - Drop down lists

Drop down lists

RE: drop down lists

Excel articles

Excel tip:

Enter formulae into multiple cells