Returning a value based on whether a cell value @row can be found in another column in another sheet

shuang

Hi Smartsheets Community,

I am trying to create a formula that returns a "Yes" or "No" value after checking whether the cell value in that row matches a value in a column in a separate sheet.

=IF(INDEX({Master Governance Sheet ID}, MATCH([ID Number]@row)), "Yes", "No")

I am getting an error in the formula. Any suggestions?

Thank you!

Kelly P.

@shuang If you want to use an IF function, you could try this:

=IFERROR(IF(INDEX({MasterGovernanceSheet_ID}, MATCH([ID Number]@row, {MasterGovernanceSheet_ID}, 0)) = [ID Number]@row, "Yes"), "No")

Hope this helps!