EXCEL 2007

Please check out:-

http://www.pierrefondes.com/

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.

"Joe Spindola" wrote:

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.