index match using multiple spreadsheets return text YES OR NO

emthaolinh · May 16th 2021

[xpost][/xpost]

X post

mrexcel.com/board/threads/inde…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.

**royUK** · May 17th 2021

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

https://www.excelguru.ca/content.php?184

index match using multiple spreadsheets return text YES OR NO

Participate now!

Share

Users Viewing This Thread