Formula HELP!!

[Jillian Secrest]

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

[#2 · Accepted solution]

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

[#3]

Sergei,

I love you! This worked perfect, after I adjusted it to match my criteria, Thank you oh so much!

[#4]

Jillian, glad to help