| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating linked lists in Excel
I am creating a budgeting tool in Excel and I want to be able to group my
expenses into categories with corresponding subcategories. Here's a generic example: Fruit: Bananas Apples Pears Veggies: Carrots Peas Beans Ideally I would be able to select the upper category from a list for each buget item and then in the adjoining column I would be able to select items in list from the relevant subcategory. I've tried using vlookup/hlookup/lookup/etc. but I am coming up short. I have to believe this is a relatively common request. Is there a web site or some other source of info that you can point me to? Thanks for your help in advance. John |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
creating linked lists in Excel
See http://www.contextures.com/xlDataVal02.html
"Jack Vail" wrote: I am creating a budgeting tool in Excel and I want to be able to group my expenses into categories with corresponding subcategories. Here's a generic example: Fruit: Bananas Apples Pears Veggies: Carrots Peas Beans Ideally I would be able to select the upper category from a list for each buget item and then in the adjoining column I would be able to select items in list from the relevant subcategory. I've tried using vlookup/hlookup/lookup/etc. but I am coming up short. I have to believe this is a relatively common request. Is there a web site or some other source of info that you can point me to? Thanks for your help in advance. John |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
creating linked lists in Excel
This is perfect!!! Thanks so much for your help!
"Sheeloo" wrote: See http://www.contextures.com/xlDataVal02.html "Jack Vail" wrote: I am creating a budgeting tool in Excel and I want to be able to group my expenses into categories with corresponding subcategories. Here's a generic example: Fruit: Bananas Apples Pears Veggies: Carrots Peas Beans Ideally I would be able to select the upper category from a list for each buget item and then in the adjoining column I would be able to select items in list from the relevant subcategory. I've tried using vlookup/hlookup/lookup/etc. but I am coming up short. I have to believe this is a relatively common request. Is there a web site or some other source of info that you can point me to? Thanks for your help in advance. John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked Lists / Data Validation - Excel 97 | Excel Worksheet Functions | |||
| Creating frequency lists in Excel | Excel Discussion (Misc queries) | |||
| linked text ranges or lists | Excel Discussion (Misc queries) | |||
| Access or Excel for contact info lists & creating mailing labels | Excel Discussion (Misc queries) | |||
| Creating Pull Down Lists in Excel cells. | Excel Discussion (Misc queries) | |||
Hybrid Mode
