Fill other cells based on cell selected

[Keith]

How can I have other cells fill in with data from another worksheet based on the cell that I select in the active worksheet?

i.e. I have a list of names in column B when I select a cell containing a name I would like that persons phone # and other info to appear in other cells. As I scroll down the phone # and other info would change according to the name in the active cell.

The phone # and other info is in a named range in another worksheet.

Thanks,
Keith

 

[Gord Dibben]

Keith

Some VLOOKUP formulas and a lookup table should do the trick.

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

 

[Keith]

Thanks. I give that a try.
Keith

Keith

Some VLOOKUP formulas and a lookup table should do the trick.

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