choose? lookup?

[Guest]

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!

 

[Tom Ogilvy]

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.