Results 1 to 4 of 4

Thread: getting information relative to indirect source

  1. #1
    New Member
    Join Date
    Apr 2019
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default getting information relative to indirect source

    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


    Fish
    Trout 12
    Halibut 15.4
    Red_Snapper 8

    Fruit
    Apple .3
    Banana .5
    Peach .4

  2. #2
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,112
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: getting information relative to indirect source

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

    M.
    Last edited by Marcelo Branco; Jun 25th, 2019 at 09:39 AM.

  3. #3
    New Member
    Join Date
    Apr 2019
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: getting information relative to indirect source

    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.

  4. #4
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,112
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: getting information relative to indirect source

    You are welcome. Thanks for the feedback.

    M.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •