Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi, I'm trying to find the formula for entering a value in a cell based on
multiple criteria. I'm working on a solar heating sheet. I have a drop down menu to select a State (only 2 at the moment) and another drop down menu to select the angle of tilt on the solar panel. (8 angles to choose from) I would like it to work like this: If the state is THIS, and the angle is THIS, then enter the value of THIS cell I'm new but I have managed quite a complex worksheet so I can pick it up. I am, however stumped at this point. Any help is appreciated. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |