populate table with data depending on item selected in drop down list

Hi ,

SORRY ABOUT FORMATTING THIS IS MY FIRST POST.

i have 3 Sheets;
Sheet1 is for data input it contains 3 Columns :Name | Description| Type <--------- is a drop down list, which is populated from the column headers in sheet 2
Sheet 2 contains a table with data. It is structured like this;
Boy| Girl <------Column Headers
eye colour
height
weight
hair colour
^
Attributes

Sheet3 Is the output sheet its combine the columns from sheet 1 and the attributes in sheet 3, The columns would look like this ;

Name |Description| Eye Colour| Height| Weight| Hair Colour

Scenario:
User enters on sheet1 Bob , arts, Boy . I would then like for Sheet 3 to populate with ;

Name|Description| Eye Colour|Height|Weight|Hair Colour
Bob Arts ..... ...... ..... .........

So what ever options was picked in the dropdown list it would get those attributes(from Sheet2) and display in the correct columns( in Sheet 3)

Thanks

Hi ,

Thanks for you reply but my file is too big to upload. I will use WeTransfer:
https://wetransfer.com/downloads/500...9052502/32bafb

Hi Ali,

Please find attached example data

Attached is updates excel sheet of what im looking for.

Yes, what i would like to see it what the the user enters the corresponding data will be displayed along side the entered data.

I have figured out if i Transpose the rows and columns , i can use Vlookup .

but it is not working;
im using

=IFERROR(VLOOKUP([@Attribute],tbl_items,3,0),"").

It does not recognice @Attribute, why would this be?

Please find attached excel sheet

Sorry , my bad , the vlookup formula i would like help with is in cell B52

Thanks , i have update the excel sheet.

I would like to have the information displayed under the new headings shown in the sheet(under the table)