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

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.


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,


Best Answers


  • sean59916
    sean59916 ✭✭✭

    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!