VLOOKUP on a multi-select column



Say I have a multi select column with 4 possible choices (North, South, East, West). If North and South are selected, is it possible to write a VLOOKUP to pull the first selection, and then write a second VLOOKUP to pull the second selection? In other words, is it possible to parse multi-select columns?

Thank you.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!