SOLVED

Index Match returning Yes/No

New Contributor

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:

 

tsw02_0-1621610763566.png

 

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".

2 Replies
best response confirmed by tsw02 (New Contributor)
Solution

@tsw02 

In C2:

 

=IF(B2=INDEX([Book2]Sheet1!$B$2:$B$5,MATCH([Book2]Sheet1!$A$2:$A$5,0)),"Yes","No")

 

Fill down.

That is actually the formula I originally tried, but it was returning incorrect results. Your response made me realize that it wasn't the formula that was wrong, some of the amounts had multiple decimal places which threw off the results.

Thank you!