VLOOKUP formulas will pull the data to appropriate cells.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Fri, 28 Sep 2007 10:49:00 -0700, SallyM
wrote:

Hello - I am building an competitive repository and I want to have a first
sheet summary page of a complete list of companies and then create link (on
the summary page) to a complete description of that company located on
another sheet within the same file? Can I do that? If so how?