Workaround for VLOOPUP with multiple search values

09/10/20
Answered - Pending Review

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!

Answers

Sign In or Register to comment.