![]() |
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 . |
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