Can I Create It? Inventory/pull list

[Kel]

I am trying to create a invoice/pull list for a warehouse in excel. I need
to know if there is a way for me to put a item name in and it pull up
everthing that should be pulled for that item?

For example:
A customer would like a tent

if I enter 10*12 tent
it pulls up
4 tent sides
1 pop up tent
stakes

Is that possible?

 

[Pete_UK]

Sounds like dependent data validation may be of use to you - Debra
Dalgleish shows how here:

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

You could then use VLOOKUP formulae to bring across related data.

Hope this helps.

Pete