vlookup help

[David McCue]

I have a column on one sheet (green) that I want it to look up info from the 2nd tab and fill it in.
I was thinking vlookup to solve this but I am not very good at these.

So I want to select a vehicle type from a drop down list in sheet called "Checklist" cell is $g$10 (yellow cell)
then it needs to look at cells b1:z1 in sheet called "MEL" to match the vehicle type from G10

and return the info below that vehicle type on sheet "Checklist" in H12:H60 (Green cells)

Can anyone offer assistance please

 

[Yongle]

am I missing something?
Where is Baggage Tug (Diesel) in sheet MEL?

EDIT
Found it

 

[Yongle]

The values in row1 in MEL must be the same to the value in G10, otherwise the lookup will fail
So if you have used {ALT}{ENTER} to make cell B1 etc look nice either remove it or add another (hidden) row for your lookup

this formula in H12 copied down should work
=INDEX(MEL!$1:$1048576,MATCH(G12,MEL!$A:$A,0),MATCH($H$10,MEL!$1:$1,0))

you could amend the formula to include actual ranges used - like this
=INDEX(MEL!$A1:$T99,MATCH(G12,MEL!$A1:$A99,0),MATCH($H$10,MEL!$A1:$T1,0))

 

[Yongle]

OOPS - the lookup cell is of course G10
=INDEX(MEL!$1:$1048576,MATCH(G12,MEL!$A:$A,0),MATCH($G$10,MEL!$1:$1,0))

 

[David McCue]

Thanks -I didnt think of an index formula
The 1st formula works a treat - I just had to change the $h$10 to $g$10

 

[Yongle]

well spotted