True/False VLOOKUP if cell on one sheet appears anywhere in column on another sheet

I'm trying to created a VLOOKUP formula the checks whether a cell value that lives on the same sheet as the formula can be found in anywhere in a column on a corresponding sheet. The formula should return a True/False value, or check a checkbox - whichever is simplest. I'm fairly certain the cell value should appear as '[Requester Email]@row' and the reference column should appear as '{Shared Contact Email}' I'm not sure how to write the logic for the True/False/checkbox response.

=VLOOKUP([Requester Email]@row, {Shared Contact Email}, ?)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!