Data from more than one cell on one worksheet into a single cell

[Guest]

I want to be able take a worksheet which shows repository names in Column A, Street Address Column B, City Column C, State Column D, Zip Column E and phine number in Column F. ie a typical address book listing and have the name and address inputted in the repository column on another worksheet when a particular repository is choosen from a dropdown list on the destination sheet. For example: Repository is ABC Public Library. In the sheet I am entering data in I select ABC Public Library, and when I click on this name the information for the name, address and phone number of the repository is entered into the appropriate column in my data entry sheet under Repository Column. Is this possible without having to do alot of programming. What I know about excel I have taught myself and I am a real newbie. I tend to play around with programs trying to figure out how to get it to do what I want

Thanks for your help

 

[macropod]

Hi Beth,
Having set up your dropdown list in cell A1 of your Repository sheet, you
could use the following formula:
=INDEX(Name&CHAR(10)&StreetAddr&CHAR(10)&City&",
"&Zip&CHAR(10)&Phone,MATCH(A1,Name,0))
in the cell in which you want the results to appear. Format the cell with
text wrapping and adjust the height & width Or use cell merging) to get it
to display correctly. The CHAR(10) inserts line feeds at the appropriate
place.

Cheers

I want to be able take a worksheet which shows repository names in Column

A, Street Address Column B, City Column C, State Column D, Zip Column E and
phine number in Column F. ie a typical address book listing and have the
name and address inputted in the repository column on another worksheet when
a particular repository is choosen from a dropdown list on the destination
sheet. For example: Repository is ABC Public Library. In the sheet I am
entering data in I select ABC Public Library, and when I click on this name
the information for the name, address and phone number of the repository is
entered into the appropriate column in my data entry sheet under Repository
Column. Is this possible without having to do alot of programming. What I
know about excel I have taught myself and I am a real newbie. I tend to
play around with programs trying to figure out how to get it to do what I
want.

 

[macropod]

Oh,

and name your data ranges as per the example (i.e. Name, StreetAddr, City,
Zip & Phone)

Cheers

I want to be able take a worksheet which shows repository names in Column

A, Street Address Column B, City Column C, State Column D, Zip Column E and
phine number in Column F. ie a typical address book listing and have the
name and address inputted in the repository column on another worksheet when
a particular repository is choosen from a dropdown list on the destination
sheet. For example: Repository is ABC Public Library. In the sheet I am
entering data in I select ABC Public Library, and when I click on this name
the information for the name, address and phone number of the repository is
entered into the appropriate column in my data entry sheet under Repository
Column. Is this possible without having to do alot of programming. What I
know about excel I have taught myself and I am a real newbie. I tend to
play around with programs trying to figure out how to get it to do what I
want.