ExcelBanter - Drop down menus

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Drop down menus (https://www.excelbanter.com/excel-worksheet-functions/229396-drop-down-menus.html)

Emerald1170

Drop down menus

Is there any way in Excel 2003 that I can click a name on a drop down list
and get other information to come up in other cells? ie if I click a client
name in a drop down list can I get their address information to come up in
another cell on the same worksheet?

Luke M

Drop down menus

Yes. You'll need to setup a table, but take a look in XL help file at the
LOOKUP and VLOOKUP functions.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Emerald1170" wrote:

Is there any way in Excel 2003 that I can click a name on a drop down list
and get other information to come up in other cells? ie if I click a client
name in a drop down list can I get their address information to come up in
another cell on the same worksheet?

All times are GMT +1. The time now is 05:48 AM.