Drop Down List Returning values

[mrggutz]

I'm trying to create a drop down list that when I select a value it returns the matching criteria in other cells. I can create the drop down list no problem but when i try to use vlookup it gives me 0 as a returned value(error...lol).
In A9 I have drop down list created if I select Gear Box I would like B9-B17 to return matching criteria for Gear Box and so forth if I choose another item from drop down list.
I have attached a sample of what im working on.
I'm sure this has been asked before but I can't get it to work like some of the others I've seen.

thx in advance

[MarvinP]

Hi mrggutz,

You Look at the attached to see how vlookup works off a dropdown. I hope this works for your data. If not read up on HLookup and see if structuring your data horizontally is better for you.

[mrggutz]

thx I will take a look at it.

[mrggutz]

that works great thx, im reading on Hlookup now seems to be helpful.