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