See attached sheet....
I thought a Vlookup was the way to go here but it's not returning the value I want.
On the "Consultant" Sheet, I want the chart to return the commission rate (from the commission level chart) based on the value of $B5*C$1. It's doing the value below...I tried to change how the commission level chart is shown but it's still not doing it right....
On the right, I've included what I want it to return.
When the lookup value is smaller than the first entry in the lookup table (in this case 450*1 is less than 849), then VLOOKUP() returns N/A. I think you are wanting to shift the lookup values in your lookup table down one row:I think you also want absolute references to your lookup table -- $A$3:$B$8 so that Excel keeps the correct reference when the formula is copied.
0 -- 20% 850 -- 22% 1500 -- 23% and so on
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks