Hey all, I'm trying to create a commission calculator that will pull the percentages from a table based on the row and the column. The problem I've ran in to is that there are ranges of data for both the row and the column and I don't really know enough about excel to figure this out. I want the commission percentage to be pulled up based on the net spread (the net profit) and the net markup. I have a formula in there that would work if there weren't ranges of data being used so I'm not sure where to go from here. Any help would be greatly appreciated. Thanks.
Bookmarks