Jan 15 2019 09:53 PM
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.
Jan 16 2019 02:03 AM
SolutionHi 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
Jan 16 2019 08:15 AM
Sergei,
I love you! This worked perfect, after I adjusted it to match my criteria, Thank you oh so much!
Jan 16 2019 02:03 AM
SolutionHi 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