VLookUP

MForston

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?

Paul Newcome

Try this:

=INDEX(COLLECT({Column To Pull From}, {Multi-Select Column}, HAS(@cell, [Product Type]@row)), 1)

MForston

Thank you! I will try this

MForston