I have a list of accounts, and a table that gives a range of accounts and
then the corresponding grouping. I need to assign a grouping to each value
in my list of accounts. The grouping table has about 6000 lines, so I need
to use some kind of lookup function to do the assignment. The data looks
something like this:

Accounts: Grouping:
0001-1000 Loans
1001-2000 Deposits
2001-3000 Equity

and so on... Any suggestions on how to do a lookup on this data would be
much appreciated!