Greetings,
I needed a help in an Excel file (attached to this discussion). In the "SOURCE" tab, there will be an 'infinite' lists of questions and answers.
Is there a formula you can help me with, in the tab "DICTIONARY", when I select one specific question (cell A2), the appropriate answer automatically injects itself in cell B2.
My aim is to avoid scrolling the SOURCE tab to find the answers.
The Excel file is in French.
Thank you for your help
Regards,
Krishna