VLookup in a form

[theresaluff]

Hi

I am in the process of creating a catalogue, I understand the logic of
what I need to do but am falling down on the technical aspect. To
explain:

In a form I need to make sublists of sublists of sublists ie, From a
drop down list of departments (Admin, Maintenace, Catering) select one
department and then in another drop down list of positions (eg
Catering - Chef, Server, Cleaner, etc) and then from this list have
another drop down list of equipment used (Pans, Mops, etc.)

I have 1 Master list with ALL Departments, postions and equipment.
Also when choosing the equipment I need to fill 4 columns at once,
Part No., Part Name, Number in pack and price.

Is Vlookup the way to go to be able to put this in a printable form
format?

Any suggestions welcome

 

[NoodNutt]

G'day Theresa

you should visit Debra Dalgliesh's website

www.contextures.com/tiptech.html

She has some great stuff relating to filtering data via data validation
dropdowns.

HTH
Mark.