Forum Discussion
Advanced Referencing Help
In Cell K11, I have a data validation list of exercises. The list is located in another sheet (in picture 2). In cell K10, I want to reference K11 to give me the contents of cell B2, automatica...
In K10 you may use something like
INDEX(Sheet2!B2:B3,MATCH(K11,Sheet2!A2:A3,0)