under standing if statments

[Guest]

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

 

[Ron Rosenfeld]

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

 

[Gord Dibben]

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