Trying to write a Cross-Sheet Formula with multiple criteria

KLo_

I am trying to search my source sheet to find if the "Item" equals "Food Item A" and the store number matches the target sheet store number, then enter "Y"

Any suggestions?

JuliannaK

Not sure the layout of your sheets but maybe try this:

=if(countifs(Source Sheet Item:Source Sheet Item, "Food Item A", Source Sheet Store Number:Source Sheet Store Number, Target Sheet Store Number@row)>0,"Y", "N")

You'd have to enter in your column names as they are in the sheets of course, but that gives you a rough idea.

JuliannaK

Not sure the layout of your sheets but maybe try this:

=if(countifs(Source Sheet Item:Source Sheet Item, "Food Item A", Source Sheet Store Number:Source Sheet Store Number, Target Sheet Store Number@row)>0,"Y", "N")

You'd have to enter in your column names as they are in the sheets of course, but that gives you a rough idea.

KLo_

Thank you so much @JuliannaK !! I have tried it and it worked! Amazing stuff!