index match

Originally Posted by coda1395

For example, Store 1002 and Jodi = B. On the items tab, where Jodi and B match, I would like a Yes or 1 in that corresponding cell.

Where do you want the Yes or 1 to appear (it's not on your attachment).

Where is the corresponding cell for that?


From your description, I would think you want this:

Copy this formula to E2 and copy/paste to fill the section as needed.

=IFERROR(IF(INDEX(Stores!$1:$1048576,MATCH(E$1,Stores!$A:$A,0),MATCH(ITEMS!$A2,Stores!$1:$1,0))=$D2,1,""),"")

Something like =INDEX(Stores!$A$1:$E$7;MATCH(ITEMS!E$1;Stores!$A$1:$A$7;0);MATCH(ITEMS!$A6;Stores!$A$1:$E$1;0)) in E6 ?

( Kristy has an extra space giving errors) ( replace the semicolons with commas)

May be this?

In E2 Cell


=IF(IFERROR(INDEX(Stores!$A:$E,MATCH(E$1,Stores!$A:$A,0),MATCH(TRIM($A2),Stores!$1:$1,0))=$D2,0),"Yes","")


Drag it down and right...