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.


[TABLE="width: 500"]
<tbody>[TR]
[TD]Category[/TD]
[TD]Indirect(item in category)[/TD]
[TD]Weight[/TD]
[/TR]
[TR]
[TD]Fish[/TD]
[TD]Trout[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fruit[/TD]
[TD]Apple[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Fish
[TABLE="width: 500"]
<tbody>[TR]
[TD]Trout[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Halibut[/TD]
[TD]15.4[/TD]
[/TR]
[TR]
[TD]Red_Snapper[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

Fruit
[TABLE="width: 500"]
<tbody>[TR]
[TD]Apple[/TD]
[TD].3[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD].5[/TD]
[/TR]
[TR]
[TD]Peach[/TD]
[TD].4[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.