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?