How do I populate an entire row by choosing one cell from a list

[Guest]

I need to create a spreadsheet template that is used multiple times daily.
The list source is on one worksheet and the template is on the other sheet.

I want to be able to choose one value in the list, and have the adjacent
cells in the cell's source list row automatically populate on the template.
for example:

Source List:

NAME AGE HEIGHT WEIGHT
jones 27 72' 210lbs
smith 32 68' 185lbs

On the template page, I would like to be able to choose the name "jones",
and have the age, height, and weight automatically populate on the template.

Thanks in advance for your assistance.

 

[Gord Dibben]

You could use Data Validation to create a drop-down for entering the name and a
lookup table and VLOOKUP formulas to return the Age, Height and Weight.

See Debra Dalgleish's site for more info on these two.

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

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


Gord Dibben MS Excel MVP

I need to create a spreadsheet template that is used multiple times daily.
The list source is on one worksheet and the template is on the other sheet.

I want to be able to choose one value in the list, and have the adjacent
cells in the cell's source list row automatically populate on the template.
for example:

Source List:

NAME AGE HEIGHT WEIGHT
jones 27 72' 210lbs
smith 32 68' 185lbs

On the template page, I would like to be able to choose the name "jones",
and have the age, height, and weight automatically populate on the template.

Thanks in advance for your assistance.

Gord Dibben MS Excel MVP

 

[Guest]

That is what I thought, but could not wrap my mind around the vlookup.

Using the vlookup tutorial provided, I was able to figure it out.

The other problem I had was that there are times when lines in the template
would not have entries, and how to make the adjacent cells appear blank
instead of the #N/A error. The problem was solved using the following
formula.

=IF(A1>0,VLOOKUP(A1,Sheet2!A$1:C$31,2),"")

Thanks for the help.