SOLVED

Formula HELP!!

Highlighted
New Contributor

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:GData columns C:GTable referenceTable reference

3 Replies
Highlighted
Solution

Hi Jillian,

 

With data like this

image.png

image.png

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

Highlighted

Sergei,

 

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

Highlighted

Jillian, glad to help