IF, IFERROR and MATCH Formula

[Glenlim]

Hi there,

I have attached 2 sample data set  - Data 180124 and Data 190124

What I want know is how do I incorporate the IF, IFERROR and MATCH formula within the same IF formula into Alteryx -

1. I want to know which ID from Data 190124 has a 'Requires Manual Checking' Comment, and IF Value is True, will be labelled as 'No'

2. IF Value is False, will look into Data 180124 to MATCH ID from Data 190124 to Data 180124 and IF Value is Error will be labelled as 'No'

Thank you!

[binuacs]

@Glenlim Can you provide the expected output?

[Glenlim]

For requires manual checking, there should be 2 data - FKG.252.GLD and KDI.193.LKG

There should be 7 similar data and 2 different data (BCD.456.123 and XHD.694.JFM) when comparing both data sets