Enter 1, 1001, 2001,... in Col A (A1, A2,...)
In B enter Loans, Deposits,... (in B1, B2,..)
i.e. instead of 1-1000, 1001-2000 simply have 1, 1001, 2001,...

Now with account number in C1
=VLOOKUP(C1,A:B,2,TRUE)
will give you Loans, Deposits,... as appropriate

"Carissa" wrote:

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!