SOLVED
Home

Formula HELP!!

Jillian Secrest
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.

Sample1.JPGData columns C:GSample2.JPGTable reference

3 Replies
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

Sergei,

 

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

Jillian, glad to help

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies