Formula returning Invalid Column Value

Andrea Zenner

Hello,

I'm struggling with a formula that is returning an in valid column value error. All columns are Text/Number.

Sheet 1 has one row for each project. Sheet 2 has a column that may have multiple project numbers in the same field. I need to return the value in the Status field (which is a drop down) if the project number found in Sheet 1 is contained in the project number(s) column in Sheet 2.

I thought the issue might have been the pick list column so I created a helper column called Status Text that pulls the status from the pick list column. (Formula is just =Status@row)

This is the formula that is returning the error. What am I missing? Am I not using contains correctly?

=IF(CONTAINS([Project Job Number]@row, {Project Job Number}), {Status Text}, "Not Found")

Thanks much!

Andrea Zenner

I was being silly. I didn't need the contains part, I could use a simple INDEX/MATCH. This is answered.