Im doing a VLookUp (FX: VLookUp([Product Type]@row, {Product Type Assign PCM Range 2}, 2, False) Where the [Product Type] is a column that allows multiple values in the cell. When there is multiple values in the cell my formula will error out. But I want it to be able to give me both. The column that has this formula I set to be able to have multiple values also. But it will only give me an error. Any Thoughts on how to get it to work with only having one value in the cell?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!