Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup within a range
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Range Lookup AGAIN! | Excel Worksheet Functions | |||
Lookup range help | Excel Discussion (Misc queries) | |||
help with lookup and range | Excel Worksheet Functions | |||
Lookup in a range. | Excel Discussion (Misc queries) | |||
Range Lookup | Excel Discussion (Misc queries) |