Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup and tables
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup in Tables | Excel Worksheet Functions | |||
Lookup Tables | Excel Worksheet Functions | |||
lookup tables | Excel Worksheet Functions | |||
Lookup tables | Excel Worksheet Functions | |||
lookup tables | Excel Worksheet Functions |