Conditional functions
 

Can someone please help, I want to achieve the following.

2 worksheets, results and data
Data sheet has the following colums
Size Wegcost Cempcost
0.75 £120 £100
1.1 £90 £95
1.5 etc etc
1.5
2.2
3.0
4.0
5.5
7.5

Results sheet has 3 cells say A1 and B1
A1 has a combo box which lists the sizes from data sheet colum A1
B1 has a combo box which lists the name Weg-Cemp.
How do get the cost of a size based on which name is chosen.
There is a total cell say F1 which is the SUM of B1:E1
Can someone help, my brain is in overload.
many thanks
Andy

Let's say your data appears in the range A2:C20, assuming row 1 has column
headers. Let's also assume that the combo boxes are linked to cells named
Size and Cost, and that the Cost results can be "Weg" or "Cemp"

=vlookup(size,A2:C20,if(cost="Weg",2,3),false)


"Big Jones" wrote:

Can someone please help, I want to achieve the following.

2 worksheets, results and data
Data sheet has the following colums
Size Wegcost Cempcost
0.75 £120 £100
1.1 £90 £95
1.5 etc etc
1.5
2.2
3.0
4.0
5.5
7.5

Results sheet has 3 cells say A1 and B1
A1 has a combo box which lists the sizes from data sheet colum A1
B1 has a combo box which lists the name Weg-Cemp.
How do get the cost of a size based on which name is chosen.
There is a total cell say F1 which is the SUM of B1:E1
Can someone help, my brain is in overload.
many thanks
Andy