Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
under standing if statments
I am trying to create a drop down box and with what ever i select from it put
the price two cells over say backhoe cost is 44.57 hr backhoe trencher blade will be in the list in a1 and i want it to put the prices in d1 and there will be diffrent prices for every pice of equipment thanks e |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
under standing if statments
On Sat, 21 Jul 2007 13:04:01 -0700, zx12rbullet
wrote: I am trying to create a drop down box and with what ever i select from it put the price two cells over say backhoe cost is 44.57 hr backhoe trencher blade will be in the list in a1 and i want it to put the prices in d1 and there will be diffrent prices for every pice of equipment thanks e Depending on how you have your pricelist setup, you likely will need one of the LOOKUP functions. Probably VLOOKUP --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
under standing if statments
VLOOKUP formulas will pull the data to appropriate cells based upon the item in
A1 See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Gord Dibben MS Excel MVP On Sat, 21 Jul 2007 13:04:01 -0700, zx12rbullet wrote: I am trying to create a drop down box and with what ever i select from it put the price two cells over say backhoe cost is 44.57 hr backhoe trencher blade will be in the list in a1 and i want it to put the prices in d1 and there will be diffrent prices for every pice of equipment thanks e |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avoiding €śnew message€ť window popping up when standing on an e-ma | Excel Discussion (Misc queries) | |||
about the dot standing alone | Excel Discussion (Misc queries) | |||
AND OR IF Statments | Excel Worksheet Functions | |||
assigning class standing based on grade | Excel Discussion (Misc queries) | |||
If Statments containing letters | Excel Discussion (Misc queries) |