Hi Nick

I did use a lookup to create my formula. So when I select a model then the
base price comes up. So you are saying to create the same idea using the
lookup formula so that when i select the model number then the base price
(which already appears) then i can auto fill? So I would put all of my of my
standards and opitions on a seprate sheet and then use the vlook up formula?

Thanks


"Nick Hodge" wrote:

Stacey

Has this model been built for you? I suspect the price is using a VLOOKUP
already to 'autopopulate'. My answer just expanded on this to do the same
for the other variables

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


"Stacey" wrote in message
...
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