Forum Discussion

Jillian Secrest's avatar
Jillian Secrest
Copper Contributor
Jan 16, 2019

Formula HELP!!

I need help. I am ultimately trying to index data on a separate C:G), based off of a store number, on a different table in column "A" and if it is equal to heading of Column "B" I need it to give me the info in column 5 (G) in data sheet. This seems like it should be extremely easy, but I just can't figure out what I should.

Data columns C:GTable reference

  • Hi Jillian,

     

    With data like this

    the formula in B2 is

    =IFERROR(INDEX(Sheet1!$G$2:$G$19,MATCH(1,INDEX((B$1=Sheet1!$F$2:$F$20)*($A2=Sheet1!$C$2:$C$20),0),0)),"")

    and drag it to the right and down

  • Hi Jillian,

     

    With data like this

    the formula in B2 is

    =IFERROR(INDEX(Sheet1!$G$2:$G$19,MATCH(1,INDEX((B$1=Sheet1!$F$2:$F$20)*($A2=Sheet1!$C$2:$C$20),0),0)),"")

    and drag it to the right and down

Resources