choose? lookup?
 

I'm trying to set up a report that calculates fees in order to validate fee
calculations on another system. Column one contains a reference to a fee
schedule; i.e. schedule A, schedule B etc. Column 2 contains the account
value. So I need to look up the appropriate schedule, use the appropriate
calculator and return the result into column 3. Part of my problem is that
the fee calculators are not in a single cell, although I could probably
re-write them if I have to. (The fee calculators discount for higher
balances- i.e. 1.00% of the first $500,00, .85% of the next $500,000, .75% of
the next $1,000,000, etc) Any ideas and/or formatting suggestions would be
appreciated!

choose? lookup?
 

You can make calculated cell references including sheet names using the
indirect function. You can combine this with the Vlookup function to return
data from a table.

These are worksheetfunctions, not VBA.


--
Regards,
Tom Ogilvy

"Gorsimmons" wrote in message
...
I'm trying to set up a report that calculates fees in order to validate
fee
calculations on another system. Column one contains a reference to a fee
schedule; i.e. schedule A, schedule B etc. Column 2 contains the account
value. So I need to look up the appropriate schedule, use the appropriate
calculator and return the result into column 3. Part of my problem is that
the fee calculators are not in a single cell, although I could probably
re-write them if I have to. (The fee calculators discount for higher
balances- i.e. 1.00% of the first $500,00, .85% of the next $500,000, .75%
of
the next $1,000,000, etc) Any ideas and/or formatting suggestions would
be
appreciated!