Forum Discussion
Commission % drop down
HI all. So, this is why my brain is hurting. Please help. I have a basic spreadsheet that I track my orders, and commission rates. Depending on who the customer is I receive either 2% or 6% ...
either add another column for that drop down and then column K would have the calculated commission or use a lookup table and use XLOOKUP or VLOOKUP. So if you make J7 the drop down then K7 would be =I7*J7
If you have a lookup table it would be something like =I7*XLOOKUP(A7,Table1[name],Table1[commission],0)
If you have a lookup table it would be something like =I7*XLOOKUP(A7,Table1[name],Table1[commission],0)
is there a way to post a screen shot of my spreadsheet? Or to reply to you directly?