I'm trying to write a formula where if the values of two columns in sheet1 match the values of two columns in sheet2, it returns a value of "Yes" in a third column of sheet1. How can I accomplish this?
I'm trying to write a formula where if the values of two columns in sheet1 match the values of two columns in sheet2, it returns a value of "Yes" in a third column of sheet1. How can I accomplish this?
Assuming your data is in A1:A10 & B1:B10 on both sheets.
=IF(SUM(A1:A10,B1:B10)=SUM(Sheet2!A1:A10,Sheet2!B1:B10),"Yes","No")
possibly that will work it would be eaiser to have a upladed workbook as it may yeild a alternative solution pending on your data
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks