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! :)

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! :)

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! :)