Orientation of collector
Tilt of collector South SE/SW E/W NE/NW North
Horizontal 933 933 933 933 933
30 degrees 1042 997 886 762 709
45 degrees 1023 968 829 666 621
60 degrees 960 900 753 580 485
Vertical 724 684 565 427 360

I need to make it so Excel will Lookup a piece of data in the above table
when someone writes in the Tilt of the collector in one cell, and the
orientation in another.

IE Tilt of collector: 30
Orientation of collector: E
Answer (generated by formula) = 886

Can anyone help me with this? I would use IF(AND(OR but that means i would
exceed my nesting limit :(

Thanks!