Formula for return value from a seperate sheet column if another column is one of 3 values

Ethan Kohl

Hello,

I am trying to create a formula that returns the value of a lets call it Column A in a seperate sheet if Column B in that same seperate sheet is any of 3 different words.
Here is the formula as I currently have it.

=JOIN(COLLECT({Scopes Range 3}, {Scopes Range 2}, OR(@cell = "In Progress - On Time", @cell = "In Progress - Delayed", @cell = "In Progress - Ahead of Schedule"),), ";")

so the result should return for instance 2,5,7 from Scope Range 3 if Scope Range 2 equals either "In Proges - On Time", "In Progress - Delayed", or "In Progress - Ahead of Schedule".

Ethan Kohl

I figured it out as soon as I posted it. I had an extra , after Ahead of Schedule.
Correct Formula: =JOIN(COLLECT({Scopes Range 3}, {Scopes Range 2}, OR(@cell = "In Progress - On Time", @cell = "In Progress - Delayed", @cell = "In Progress - Ahead of Schedule")), ";")

Ethan Kohl

I figured it out as soon as I posted it. I had an extra , after Ahead of Schedule.
Correct Formula: =JOIN(COLLECT({Scopes Range 3}, {Scopes Range 2}, OR(@cell = "In Progress - On Time", @cell = "In Progress - Delayed", @cell = "In Progress - Ahead of Schedule")), ";")