Hi,

This is pretty vague. What does your data look like, where do you want drop
down lists and what should the drop down lists have in them?

The answer is probably yes. Have a VLOOKUP function refernce the drop down
list.

Cheers,
Shane Devenshire

"Mr.B" wrote:

I hope anyone can help......I'm reaching the end of my worksheet and can't
figure out how to do this?
I have an order to run at work and it consists of labels inserts and
cartons......but some orders have a few more components to them.....so is
there a way for the user to select from a drop down box for them to choose a
component and when they do, it will contain the right calculations to show if
they have enough and let them select from another box until they got all
components on the sheet.
--
Mr.B