choose? lookup?

[Gorsimmons]

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.


--
Regards,
Tom Ogilvy

"Gorsimmons" <[email protected]> wrote in message
news:[email protected]...
> 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!