You need to build a table that lists the states and the angles. Like this:

...........A..........B..........C
1...................20.........25
2.......AL........2..........13
3.......TX........7..........10
4.......CA.......9...........17

Row 1 are the angles and column A are the states.

Then you can use a lookup function.

For example, assume the state drop down list is in cell X1 and the angle
drop down list is in cell X2.

X1 = TX
X2 = 25

=VLOOKUP(X1,A1:C4,MATCH(X2,A1:C1,0),0)


--
Biff
Microsoft Excel MVP


"Solar Man" <Solar wrote in message
...
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.