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