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?