Forum Discussion
Solved
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 ...
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
Sergei,
I love you! This worked perfect, after I adjusted it to match my criteria, Thank you oh so much!
Jillian, glad to help