Forum Discussion
Solved
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".
In C2:
=IF(B2=INDEX([Book2]Sheet1!$B$2:$B$5,MATCH([Book2]Sheet1!$A$2:$A$5,0)),"Yes","No")
Fill down.
2 Replies
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!
