So in this book, I have a table I want my staff to be able to use. It's the bottom table. For the column starting G17, I want to have the automatically filled in. So whatever the number someone puts in at C16, I want it to grab the number from the table in K4. So for the example I uploaded, the number I input in C16 is 40, therefore I want G18-G22 to use the K4 table (specifically the N Column which is any number between 40-49). The results for this example should be G18 = (N5 x C18). G19 = (N6 x C19). G20 = (N7 x C20). G21 = (N8 x C21) and G22 = (N9 x C22).
The table at K4 will remain unchanged. Only input that changes is the C16, C and D 18 through 22. I want the 'Plus Bonus Payout to read the C16 number, find which cell it should be in the table at K4, and take those numbers to multiply it by the numbers in C18 and below...
I probably sound really confusing and I apologize because I am a very basic novice in Excel or formulas in general. As you can see, I have only been able to successfully use Sums and Products thus far.
Any help would be greatly appreciated.
Thank you!
Bookmarks