emthaolinh
New Member
- Joined
- Apr 8, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Please assist. I have 2 spreadsheets that I need to compare the values. The formula looks for the 2 fields in spreadsheet 1 in spreadsheet 2 and if it matches returns "YES" OR "NO".
IFERROR(IF(MATCH(sheet1!$E2,sheet2!$E$2:$E$5873,0)=MATCH(sheet1!$J2,sheet2!$A$2:$G$5873,0),INDEX(sheet2!$A2:$H5873,MATCH(sheet1!$E2,sheet2!$E2:$E5873,0),3),""),"YES","NO") |