getting information relative to indirect source

UntitledDocument

New Member
Joined
Apr 22, 2019
Messages
9
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.


CategoryIndirect(item in category)Weight
FishTrout
FruitApple

<tbody>
</tbody>


Fish
Trout12
Halibut15.4
Red_Snapper8

<tbody>
</tbody>

Fruit
Apple.3
Banana.5
Peach.4

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

UntitledDocument

New Member
Joined
Apr 22, 2019
Messages
9
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,064
Messages
5,472,257
Members
406,809
Latest member
haf19

This Week's Hot Topics

Top