I've been working on an INDEX/MATCH formula, but nothing seems to work. Tried a few combination of INDEX/MATCH with ANDs, IFs and/or VLOOKUPs, but I'm struggling with the syntax. And to make things even more complicated, the formula refers to a table from another tab in my .xlsx document.
The formula is to be entered in 'Bourse', cell G11.
What I'm trying to do:
Look through the table in 'GET - Investing', and return the appropriate SOMMAIRE (Column F) according to two match criteria...
- 'GET - Investing' SYMBOLE (Column B) must be the same as 'Bourse' cell $D11.
- 'GET - Investing' PERIODE (Column C) must be the same as 'Bourse' cell G$9.
Any input on the matter would be appreciated.