May 21 2021 08:29 AM
I have two workbooks with customer names and amounts due. I currently am using the index match function in workbook 1 to search workbook 2 for the customer name and return the amount due for the customer. Example below:
Instead of returning the amount in Column C, is there a formula to return a yes or no based on whether the index match returns a value that is equal to the amount in column B? So C2 and C5 would return a "yes" and C3 and C4 would return a "no".
May 21 2021 08:36 AM
SolutionIn C2:
=IF(B2=INDEX([Book2]Sheet1!$B$2:$B$5,MATCH([Book2]Sheet1!$A$2:$A$5,0)),"Yes","No")
Fill down.
May 21 2021 09:49 AM
May 21 2021 08:36 AM
SolutionIn C2:
=IF(B2=INDEX([Book2]Sheet1!$B$2:$B$5,MATCH([Book2]Sheet1!$A$2:$A$5,0)),"Yes","No")
Fill down.