# Difficult Cell Reference?! Maybe not for you!

#### actjfc

##### Active Member
Excel Warriors,

I Have a small commission table similar to:

From / To
Month / Month / Comission
1 / 15/ 5.00%
16/ 20/ 6.00%
21/ 30/ 10.00%
31/ 49/ 11.00%
50/ 57/ 15.00%
58/ 180/ 20.00%
..
..
..
..

This example only has 6 intervals, but the actual workbook has 15 intervals. The "From" and "To" months are variable cells.

Now, I also have another table with:

Index Month / Commission Month
1 / Missing Formula????
2
3
4
5
.
.
.
178
179
180

What I need to develop is a reference formula that I can copy once under the cell "Commission Month" (Missing formula) then copy down to 180 and have as a result the same commission assigned in the original small commission table. Do not forget that the original "small table" has 15 intervals. Can somebody take the challenge?

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

#### Gerald Higgins

##### Well-known Member
Hi there. I don't understand what you want. Can you give us two or three examples, showing exactly what you want the results to be ?

#### actjfc

##### Active Member
Missing Formula(if month is >= 1 and <= 15) = 5.00%

Missing formula has to change to 6%, 10% and so on as the month changes:

16/ 20/ 6.00%
21/ 30/ 10.00%
31/ 49/ 11.00%
50/ 57/ 15.00%
58/ 180/ 20.00%

Did I explain myself?

Thanks!

#### OneEyedBartender

##### New Member
Is this what you are looking for:

=INDEX("Commission Table",MATCH(Index Month,"From Month Range",1))

Replies
13
Views
233
Replies
4
Views
152
Replies
1
Views
144
Replies
0
Views
224
Replies
6
Views
217

1,191,184
Messages
5,985,175
Members
439,945
Latest member
ospe

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back