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.
<tbody>
</tbody>
Fish
<tbody>
</tbody>
Fruit
<tbody>
</tbody>
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>