Using INDEX/COLLECT with an OR statement?

Options

I'd like to pull a value from another sheet based on a cell value in my current sheet Matching either 1 of 2 columns in my other sheet.

INDEX(COLLECT({Range where value I want to pull is located}, {Column 1 where I'd like to Match cell with}, @cell, OR({Column 2 where I'd like to Match cell with}, @samecell),0))

This way, if @cell has a match of either column 1 or column 2, it pulls the value from the specified column in the beginning of my formula.

Now from what I understand about the OR operator is that it works best with definitive statements for single cells, but I need to match based on the contents of 1 of 2 column ranges.

Thanks.

Answers