If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|