Table Look Up

J

joecool12345

I am trying to calculate a commission % based on a gross profit % range. So
I have 8 rows of % ranges with 3 columns, column 1 is greater than and column
2 is less than, the third column has the commission %. Can someone tell me
how to have a formula look at the table and tell me which % should be used
for the calculation?
 
F

Fred Smith

You want Vlookup. Something like:

=vlookup(a1,$d$1:$f$1,3,true)

Make sure your 'column 1' is sorted in ascending order.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to calculate commission based on sliding scale 2
Setting column width in a table with a macro is not working 0
Sliding Commission Formula 2
Format column widths from one table to a separate table on same page 1
Cumulative formula for word table 0
column in a pivot table 1
Trying to multiply data by one cell, based on data of another 3
Help creating a sales commission formula 3

Top