Forum Discussion
Jillian Secrest
Jan 16, 2019Copper Contributor
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
- Jillian SecrestCopper Contributor
Sergei,
I love you! This worked perfect, after I adjusted it to match my criteria, Thank you oh so much!
Jillian, glad to help