View Single Post
  #1   Report Post  
Big Jones
 
Posts: n/a
Default 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