Search database

[Lawrences]

I have been trying to use several formulas (VLOOKUP, INDIRECT, INDEX etc.) however I cant seem to arrive at the correct formula. My problem is:

I am trying to create an excel sheet (named eg. Sheet1) which pulls information from Sheet2. Basically, in sheet1 you enter the name of the object and in the cells below all the information of the object will be pulled out of the database and displayed. Here is an example:
Search Sheet1 has the following cells. Basically you enter the footballers name and the rest of the information (age, weight) is displayed.

The database spreadsheet looks like the following cells on Sheet2. The age/weight/height/footballer are all arranged in columns now.

Can someone please help me write a formula into cells B2, B3 and B4 of Sheet1 so that it pulls the value of the right row in Sheet2 based on column A (footballer name).

Thanks

 

[steve the fish]

Try this in B2:

=INDEX(Sheet2!$A$1:$D$40,MATCH(B$1,Sheet2!$A$1:$A$40,0),MATCH($A2,Sheet2!$A$1:$D$1,0))

 

[Lawrences]

You, are a genius! Thanks so much!!!