need assistance on doing this formula,

In cell J5, create a VLOOKUP function that returns the salesperson commission that corresponds with the base cost of the car (in F5). Use the range $C$24:$D$28 as the Lookup Table, and return the commission rate from Column 2.


Will send fg for any quick help?

=VLOOKUP($F$5,$C$24:$D$28,2)
that will return the value from column D, which I assume is what you want

This post was edited by Azrad on Apr 22 2013 06:02pm

Here you go





This post was edited by Dmon_Hunter on Apr 22 2013 06:09pm

you really should be using offset or indirect, not vlookups.
vlookups are terribly inefficient.