ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help :-( - Auto Population (https://www.excelbanter.com/excel-worksheet-functions/93152-help-auto-population.html)

Stacey

Help :-( - Auto Population
 
Ok Excel Pros,

I am putting together a spread sheet that is (work related) that will allow
me to select a model number and the base price appears. I was able to get
that together, however for each of these models there is is a list of
standards and opitions. What i want to be able to do is when a model is
selected and the base price appears then I need I want the opitions and
standards appear for that model. 9auto fill )
Any ideas? I got some feed back yesterday however when I tried to use the
formula that was given to me it dosn't work. As it was suggested that I put
all of my information on a second page and use a vlookup as a formula.

Please advise.
Thanks

Thanks .


Ron de Bruin

Help :-( - Auto Population
 
Yes add you data on a other sheet and use Vlookup to get the data

See Debra's site for information
http://www.contextures.com/xlFunctions02.html

--
Regards Ron De Bruin
http://www.rondebruin.nl



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

I am putting together a spread sheet that is (work related) that will allow
me to select a model number and the base price appears. I was able to get
that together, however for each of these models there is is a list of
standards and opitions. What i want to be able to do is when a model is
selected and the base price appears then I need I want the opitions and
standards appear for that model. 9auto fill )
Any ideas? I got some feed back yesterday however when I tried to use the
formula that was given to me it dosn't work. As it was suggested that I put
all of my information on a second page and use a vlookup as a formula.

Please advise.
Thanks

Thanks .





All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com