Do i need Vlookup or Indirect or something else?

[MICHAELSNOWDON]

I have a simple workbook with two sheets.

Sheet 1 contains:

NAME	AGE	HEIGHT	WEIGHT
JOHN	34	52	23
PETER	23	12	62
LUCY	45	23	86
DANIEL	23	42	34

<tbody>
</tbody>

Sheet 2 contains a message: Choose a person
I then has a dropdown/combo box (data validation list, the source being the list of names from sheet 1)

So sheet 2 looks like:

Choose person:	JOHN
Age	=Sheet1!B2
Height	=Sheet1!C2
Weight	=Sheet1!D2

<tbody>
</tbody>

But obviously it be dynamic and choose relevant row instead of just row 2.



When user selects a name from the menu, the cells next to age, height and weight on sheet 2 should grab relevant data from sheet 1.

Please help with the formulas I need to do this.

 

[steve the fish]

Hi. Try like this:

=VLOOKUP($B$1,Sheet1!$A$1:$D$5,MATCH(A3,Sheet1!$A$1:$D$1,0),0)

The headers in your lookup table must be the same as the headers in Sheet2 (Age etc.)

 

[sandy666]

or use Pivot Table

 

[mohadin]

One more option

=INDEX(Sheet1!$A$2:$D$5;MATCH($B$1;Sheet1!$A$2:$A$5);ROW()-1)

 

[MICHAELSNOWDON]

Thanks for your suggestions. The problem is, the spreadsheet I have is much more complicated than my example and so the headers cannot be the same. Is there a way of posting attachments on here?

 

[sandy666]

post a link to the shared Excel FILE with representative example of data using googledrive, onedrive , dropbox or any similar