Forum Discussion
Solved
Using results of search in a formula
I have three vendors that pay different commissions on sales. How do I look up the vendor in a table, find the corresponding percentage and use that percentage in a different table to calculate comm...
=E2*XLOOKUP(D2,Sheet2!$A$2:$A$4,Sheet2!$B$2:$B$4)
=E2*XLOOKUP(D2,Sheet2!$A$2:$A$4,Sheet2!$B$2:$B$4)I used your formula and it worked fantastic on the first two vendors. On the third vendor which is in cells A4 and B4 it is giving me a #NA error. I have checked my cell references and they are all correct. If I change the vendor name the formula works. I have also checked the spelling of the vendors. Do you have any suggestions?
- Detlef_Lewin - I went in and deleted the data on Sheet2 and then reentered it. This corrected the problem. Not sure what happened but think you for your help.
