Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
Hi.
I'm hoping someone can understand what I am trying to do and point me in the right direction of where I can learn to do it. I want to have a 2 sheet document with sheet 2 explaining the formular with descriptions and costs and then be able to just put in the letter of the formular on sheet 1 and have it automatically add in the costs from sheet 2. Eg. A = Chocolate $1.50 when I put in A into sheet 1 I want it on the column next to it add in the cost of $1.50. How do I do this?? I hope this makes sence to someone! :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
just to expand a little on what I am after, the below is what I want in
columns A, B & C. REFERENCE DESCRIPTION OF WORK REQUIRED COST A GENERAL MAINTANANCE $150.00 B GENERAL MAINTANANCE + TYRES $250.00 So everytime I enter A or B into sheet one, it automatically inserts the cost into column 2. "Cazza" wrote: Hi. I'm hoping someone can understand what I am trying to do and point me in the right direction of where I can learn to do it. I want to have a 2 sheet document with sheet 2 explaining the formular with descriptions and costs and then be able to just put in the letter of the formular on sheet 1 and have it automatically add in the costs from sheet 2. Eg. A = Chocolate $1.50 when I put in A into sheet 1 I want it on the column next to it add in the cost of $1.50. How do I do this?? I hope this makes sence to someone! :) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
you could use vlookup function
so in col B you can type in: =vlookup(a3,sheet2!$a$2:$c$3,3,false) a3 is where you type "A" or "B", "sheet2!$a$2:$c$3" is where your data is. hope it helps. -- ==================== ask and you shall be answered "Cazza" wrote: just to expand a little on what I am after, the below is what I want in columns A, B & C. REFERENCE DESCRIPTION OF WORK REQUIRED COST A GENERAL MAINTANANCE $150.00 B GENERAL MAINTANANCE + TYRES $250.00 So everytime I enter A or B into sheet one, it automatically inserts the cost into column 2. "Cazza" wrote: Hi. I'm hoping someone can understand what I am trying to do and point me in the right direction of where I can learn to do it. I want to have a 2 sheet document with sheet 2 explaining the formular with descriptions and costs and then be able to just put in the letter of the formular on sheet 1 and have it automatically add in the costs from sheet 2. Eg. A = Chocolate $1.50 when I put in A into sheet 1 I want it on the column next to it add in the cost of $1.50. How do I do this?? I hope this makes sence to someone! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |