getting information relative to indirect source

[UntitledDocument]

I have a problem that seems like it should have a simple solution.
I'll use this example situation to explain.
in the first table I have data validation drop-down lists in the first column to choose a category.
In the second column i have an =INDIRECT drop-down list to get an Item out of that category.
In the third column I want the items respective weight of that item to show up automatically. That weight is stored in another table next to the where the =INDIRECT value was pulled from.

I've tried every combination of index match and a few other things, but I cant seem to get it to show.
Thanks ahead of time for taking a look at this.

Category	Indirect(item in category)	Weight
Fish	Trout
Fruit	Apple

<tbody>
</tbody>

Fish

Trout	12
Halibut	15.4
Red_Snapper	8

<tbody>
</tbody>

Fruit

Apple	.3
Banana	.5
Peach	.4

<tbody>
</tbody>

 

[Marcelo Branco]

Assuming the drop-down lists in columns A:B try in C2
=INDEX(OFFSET(INDIRECT(A2),0,1),MATCH(B2,INDIRECT(A2),0))

M.

 

[UntitledDocument]

Thanks Marcelo. That works perfect.
It turned out I had another problem that was preventing that from working the first time. You made me take a harder look at what I was doing.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.