I've tried searching for this, but either it doesn't exist or I'm using the wrong terms.
I'm trying to get a value from a table that resides next to a specific cell (the cell that says "Total") that is under-and-to-the-right of another cell (the category).
Example:
Fruits
Strawberry 20
Cherry 23
Orange 13
Total 36
I want to get the 36 out of there. There are other sections that look like that, but I want the Fruits section. So I need to locate the Fruits section and then locate the Total row underneath Fruits to obtain the 36. I thought about using a MATCH within a MATCH and then an INDEX, but I can't figure it out. Also, the original table that I'm trying to extract the information from is not editable (at least not by me).
Bookmarks