I am looking to incorporate a dropdown function in a printable sheet that references a master sheet.

[bmkelly]

I currently have a "MASTER" sheet with a list of clients names, exercises and the clients appropriate weights/settings listed. I then have another sheet called "EXERCISES" that list out different multi-trainer and incline-trainer exercises that I am wanting to utilize as a drop-down option on my "PRINT". However I run into the issue of my "PRINT" sheet utilizing a vlookup formula to find the Clients name and then the appropriate exercises but I want to be able to use the drop down on the exercises and then have the correct weight/settings for that specific exercise to show. Is this possible?

Below this is a snipshot of the "MASTER" sheet as you can see I have all the exercises labeled out but on our "PRINT" sheet we are wanting to utilize a drop down for the exercises in blue/green that way it can print in all one page and not be clustered. I was just using a vlookup formula to match the corresponding columns of the "MASTER" into the "PRINT" but I wanted to add more exercises and therefor added them individually on the "MASTER" sheet and dropdown on the "PRINT" sheet.

Below is a snipshot of the "PRINT" sheet along with the vlookup formula I was using prior to creating the "dropdown" in the blue/green cells.

 

[Sajan]

Consider using INDEX and MATCH functions in conjunction with your drop-down list on the "PRINT" sheet to dynamically retrieve the correct weight/settings for the selected exercise from the "MASTER" sheet.

 

[bmkelly]

Consider using INDEX and MATCH functions in conjunction with your drop-down list on the "PRINT" sheet to dynamically retrieve the correct weight/settings for the selected exercise from the "MASTER" sheet.

Thank you for the suggestion! You mind helping me out a little more as I just tried this and it seemed to work at first glance but then I dove into it to verify and also even added a "Test" client in the "MASTER" it doesn't seem to be pulling the accurate data? The screenshot below in Row 3 is the INDEX MATCH formula you suggested and in row 4 is the VLOOKUP formula that was previously there (however some of that data in Columns J:M are inaccurate due to having a drop down selection). I just wanted to show a comparison between the two though in case you could spot where my error may be?

I also am running into how to properly setup the INDEX MATCH formula because columns J:M will be a drop down between different exercises that are referencing the "MASTER" sheet Columns J:W as you can see the "MASTER" spreadsheet example below with all the correct data.

 

[bmkelly]

Consider using INDEX and MATCH functions in conjunction with your drop-down list on the "PRINT" sheet to dynamically retrieve the correct weight/settings for the selected exercise from the "MASTER" sheet.

Almost had it but still came up with inaccurate data pulling thru formula