INDEX & MATCH where the MATCH is based on a multi select dropdown?

Options
sean59916
sean59916 ✭✭✭
edited 08/12/20 in Formulas and Functions

Hi -

I have been trying to work this out, read through a number of threads, but, cant see this question directly answered.

Scenario:

I have 1 sheet that has a list of tools and another sheet which is used to record who those tools have been handed out to by using a multi select dropsown column. What I would like to be able to do is to have the person's name against the tool.

I have tried using: =INDEX({Who}, MATCH(HAS(@cell, Tool1), {Tool}, 0)) and different variants, but, i can't get it to work!



For example:

The tool column on the tracker sheet is using a multi select dropdown.


Is there a way to do this?

Thanks for any help,


Sean

Best Answers

Answers

  • sean59916
    sean59916 ✭✭✭
    Options

    Thanks both - It's always good to get a different perspective when spending a ton of time staring at the issue for some time. Appreciate the help.


    Sean

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!