Forum Discussion
End Result of Formula
Good day, I do not know how how to use this forum and I don't know how to properly use formulas. But here goes. I have information in columns E And O & I that can be different depending on the l...
https://1drv.ms/x/s!At19_BkxwIeUlO9oKX_BMD79fhEcjQ?e=WeDn46
Riny_van_Eekelen
Or, if XLOOKUP is not available
=IFNA( $I3*INDEX($N$7:$N$26, MATCH($E3, $O$7:$O$26, 0 ) ), 0 )Wilma_Lombaard_SAWR Have downloaded your file but don't really understand what you want to achieve.
- So this is a commission calculation document.
If the commission is coming from Supplier 4 for this order. I will enter the supplier name in column e.
There are however 19 suppliers so before I can calculate the commission in column K, I need to establish that my formula chooses the correct % commission to calculate the commission from the amount. Does that make some sense?Wilma_Lombaard_SAWR I believe either of the other respondents have already given the solution to your question.
=XLOOKUP(E3,$O$7:$O$26,$N$7:$N$26)*I3And remember best practices:
Use tables.
No blank rows or blank in tables.
No direct references (as in E3). Use data validation or type the value.
