Need to populate data from different sheet.


Joe Spindola

I have a drop down list of branch names in one sheet. The source sheet
(separate one) contains the values of this list and addresses and contact
information, as well. I need to populate adjacent cells in the one sheet with
the respective addresses and contact information, matching the selected
branch name.




EXCEL 2007

Please check out:-

Item number 57.

If you enter numbers (1 to 9 in any order) into worksheet_1 cells A2 to A10
it will pull back the corresponding values into worksheet_1 cells B2 to B10.

The, "translation table" is found in worksheet_2.

If my comments have helped please hit Yes.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question