SOLVED

New Contributor

Index Match returning Yes/No

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

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

Re: Index Match returning Yes/No

In C2:

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

Fill down.

Re: Index Match returning Yes/No

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!