Advanced Referencing Help

Shawn French
Occasional Contributor


 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, automatically.

Screen Shot 2019-01-03 at 7.38.24 AM.pngFor example, when I choose "KB Squat" in the drop-down menu of K12, I want it to automatically report cell B11 on sheet 2 to cell K10 on sheet 1.Screen Shot 2019-01-03 at 7.38.49 AM.png

 Thank you for your consideration.


2 Replies

In K10 you may use something like

Thank you Sergei!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies