Hope someone can help with this.
Please see the attached sample file. What I need is to lookup the matching 2 key IDs (i.e., ISIN and Firm_Quarters) in Sheet2 and then return the variable (i.e., market cap) in Sheet1. I have done one manually highlighted in yellow. Appreciate if someone can help me with a formula that does it automatically.
If possible, please reply to my email: email@example.com