SOLVED

VLOOKUP or other formula?

New Contributor
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
2 Replies
best response confirmed by krishnarambaccus (New Contributor)
Solution

@krishnarambaccus 

See the attached version.

On point. Thank you very much Hans