0

so I have a spreadsheet i'm using to track clients workouts. To make life easier and faster when creating the workouts i created a series of dropdowns with exercises, body parts associated with that exercise etc... So when i select a body part from the dropdown menu for example "Quads" I will get a list of quad only exercises in the next dropdown menu. My question is, is there a way I can populate the "link" cells with hyperlinks associated with the exercise selection? So when i select an exercise the hyperlink for that exercise will appear in that cell?

I have a 2nd page that contains a list of all the exercise video hyperlinks but they are categorised by body parts. I have attached pictures for a better idea of what i'm working with. Hopefully this all makes sense :)

edit: also added spreadsheet

tracker

enter image description here

Workout Tracker

5
  • Consider sharing a publicly editable sample spreadsheet with realistic-looking data, and showing your hand-entered expected results there. Use Insert > Note to describe what you want in the spreadsheet. Jun 16, 2021 at 9:23
  • Thanks I have it added :)
    – lexiDSP
    Jun 16, 2021 at 12:24
  • Thank you for sharing a sample spreadsheet. Please clearly indicate where the hand-entered expected results are. Use cell fill colors to flag the expected result cells. Jun 16, 2021 at 15:42
  • I have added notes to demonstrate what I would like the end result to be. Please let me know if there is anything i need to clarify more on :)
    – lexiDSP
    Jun 17, 2021 at 13:26
  • You can improve your chances of getting an answer that works for you by showing your hand-entered expected results. You note: "Step 1 - Selecting a bodypart here narrows down the available exercises under the "Exercise" column" — this suggests that you need a dependent drop-down list. That is another question. Post in a new topic if you need help with it. Jun 17, 2021 at 16:10

1 Answer 1

0

Put this formula in cell K6 and copy the formula cell down:

=iferror( 
  vlookup( 
    C6, 
    filter( 
      'Exercise Database'!K$1:U, 
      'Exercise Database'!K$1:U$1 = B6 
    ), 
    1, 
    false 
  ) 
)

See your sample spreadsheet.

The lookup would be simpler with query(), but it cannot reproduce clickable links.

1
  • Thank you so so much, that is exactly what I was looking for. Sorry again for any confusion caused by my lack of spreadsheet skills. You've made my job a whole lot easier :)
    – lexiDSP
    Jun 18, 2021 at 8:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.