<div>
I guess you have to use traditional way<br />
<br />
If else statement ..<br />

<pre><code id="code-8229836">http://office.microsoft.com/en-gb/excel-help/use-conditional-formulas-in-excel-to-analyze-financial-data-HA001091832.aspx</code></pre>
</div>


I guess you have to use traditional way

If else statement ..


http://office.microsoft.com/en-gb/excel-help/use-conditional-formulas-in-excel-to-analyze-financial-data-HA001091832.aspx

VLOOKUP-6.xlsx

<div>
<div class="content wysiwyg-content">
I have an excel spreadsheet that uses drop down lists to select specific items, I would like to it to autofill certain cells with set figured when a particular item is selected from the drop down list.<br />
<br />
EG. &nbsp;A spreadsheet that has a list of cars and when you selct a certain make it autofills cells for manufacturer, year, body type etc.<br />
<br />
Has anyone got any ideas on how to do this.<br />
<br />
Thanks in advance
</div>
</div>


I have an excel spreadsheet that uses drop down lists to select specific items, I would like to it to autofill certain cells with set figured when a particular item is selected from the drop down list.

EG.  A spreadsheet that has a list of cars and when you selct a certain make it autofills cells for manufacturer, year, body type etc.

Has anyone got any ideas on how to do this.

Thanks in advance

DropDown Lists in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.