creating linked lists in Excel

[Jack Vail]

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

 

[Sheeloo]

See http://www.contextures.com/xlDataVal02.html

 

[Jack Vail]

This is perfect!!! Thanks so much for your help!