Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Lookup Functions | Excel Worksheet Functions | |||
Multiple FIND functions in Conditional Formatting | Excel Worksheet Functions | |||
conditional functions | Excel Worksheet Functions | |||
conditional functions | Excel Worksheet Functions | |||
Conditional functions | Excel Worksheet Functions |