Hello Excel wizards!
I'm wondering if anybody could help me write formula that based on table A1:G4 below will:
1. In cell C10, formula that will look for trade 8361655 in the table and if "NEW" under column POSTING_TYPE and "FXO-MTM_FULL-BUY" under column ACCOUNTING_RULE then lookup the...