Your data table isn't conducive to an easy solution. Can you redesign it?

It would be much easier (simple!) if you could use separate columns for each
direction. Instead of combining SE/SW, E/W and NE/NW put each of those in
its own column:

South | SE | SW | E | W | NE | NW | North

--
Biff
Microsoft Excel MVP


"ANTBOH" wrote in message
...
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!