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?