Workaround for VLOOPUP with multiple search values


Hi all,

I would like to populate column(serial number) on sheet 1 based on information on sheet 2.

If sheet 2 column(product type) contains "A","B","C","D" take the corresponding sheet 2 column(serial number) .

This is my formula which I've tried and returns UNPARSEABLE.

IF(OR(CONTAINS("A", {sheet 2 product type}),CONTAINS("B",{sheet 2 product type}), ...), {sheet 2 serial number}@row)

Appreciate any help rendered. Thanks in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!