Hi Nick,
Thanks for the info but i am still confused. I have my model numbers in a
drop down valdiation box. In other words when I select a model number then
the right price comes up.
What my question is: How do I use a auto population to so that when I enter
the the model number the standards and opitions are auto filled?

"Nick Hodge" wrote:

Stacey

Set your variables, Model number, price, etc, etc into a table on another
sheet and reference that using VLOOKUP formulas

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Stacey" wrote in message
...
Hi Excel Pros,

I need some help. I am putting together a spread sheet @ work that will
allow me to pick a model number ( work related) and will auto populate for
each model number ( there is a 11 of them) the standards and opitions for
that model number? As each model number has a base price and that might
include additonal charges?

Can you please help me? What kind of formula would I use?
I would use an "If" formula?

Please let me know.

Thanks