propagating drop down with reference to other cells

M

mark

I am looking to build a drop down list of clients that
when selected will propagate another cell with the
client's contact info, I was thinking of building a
separate table with client name and contact info but not
quite sure how to get it all together.
 
B

Bob Phillips

Mark,

I think you have the basis of a solution. Check out VLOOKUP in help, that
should get you the rest of the way.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top