IF, IFERROR and MATCH Formula

Question

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!

Sample Data 180124.xlsx

Sample Data 190124.xlsx

Glenlim · Answer

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

binu_acs · Answer

@Glenlim Can you provide the expected output?