Sunday, March 11, 2018

yogi_Multiple Criteria Match In Two Sheets Within A Spreadsheet (WorkBook)

Google Spreadsheet   Post  #2392

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-11-2018

question by: Rob N.!topic/docs/CUD_tKZ1uFg;context-place=forum/docs
Help with an "If formula" with multiple conditions
I have account numbers that are likely to appear in two distinct columns with the same header ("Accounts") located in two separate tabs ("Main" & "Stock"). 

I need help with a formula that would return a specific text ("System") only IF the following conditions are met;

1. Two account numbers under columns B (in separate tabs) are matching; 
2. The adjacent cell ("Main" tab, Column C-"Activity) to the matching account number must contain one of these values: "Repo WL" or "Sold".

A link to the sample data :

Thank you for your help.