Hello. I am using Microsoft Excel 2003. I am trying to figure out how (or
if) I can get information to populate in multiple cells when choosing a
selection from a drop-down that is embedded in just one cell. For example:
the spreadsheet that I am working on has three different cells that I want
apply this function to-- 'Vendor Address,' 'Vendor Telephone,' 'Vendor
Account.' I have put a drop-down in the 'Vendor Address' cell so that I can
simply choose the appropriate vendor from a list. I would like my choice to
populate the correct information in the other two cells automatically-- if I
select 'ABC Vendor, 122 Main St, Anywhere' from my drop-down I would like the
telephone number and account number to automatically populate in the correct
cell. Can this be done? I realize I could just put all of the information
into one cell/one drop-down, but then I would have to modify the layout of
the company's spreadsheet and that would be... frowned upon! Any help is
most appreciated! Thank you.

Use vlookup (see Help) to return the Tel and Account based on the selected
address.

Tim

"silence13" <(E-Mail Removed)> wrote in message
news:16100024-B617-4C63-A3E4-(E-Mail Removed)...
> Hello. I am using Microsoft Excel 2003. I am trying to figure out how
> (or
> if) I can get information to populate in multiple cells when choosing a
> selection from a drop-down that is embedded in just one cell. For
> example:
> the spreadsheet that I am working on has three different cells that I want
> apply this function to-- 'Vendor Address,' 'Vendor Telephone,' 'Vendor
> Account.' I have put a drop-down in the 'Vendor Address' cell so that I
> can
> simply choose the appropriate vendor from a list. I would like my choice
> to
> populate the correct information in the other two cells automatically-- if
> I
> select 'ABC Vendor, 122 Main St, Anywhere' from my drop-down I would like
> the
> telephone number and account number to automatically populate in the
> correct
> cell. Can this be done? I realize I could just put all of the
> information
> into one cell/one drop-down, but then I would have to modify the layout of
> the company's spreadsheet and that would be... frowned upon! Any help is
> most appreciated! Thank you.

[Karthik.Kaliappan]

did you try vlookup in each of the cell i mean the 'Vendor Address,' 'Vendor Telephone,' 'Vendor
Account.' once you choose the vendro name it auto pupolate the coressponding details in 'Vendor Address,' 'Vendor Telephone,' 'Vendor
Account.'