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

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

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