index match using multiple spreadsheets return text YES OR NO

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    X post…return-yes-or-no.1171075/

    I have 2 different spreadsheets. I need a formula that will match 2 fields in columns in spreadsheet 1 with spreadsheet 2 and if there is an identical match then it will return "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")

    Please assist.

  • Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the URL from the address bar in your browser) to the cross-post. We are here to help so help us help you!

    Read this to understand why we ask you to do this