Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I always have trouble with lookups. I will try and explain what I need. I
have information in two different cells. cellE22 is 24.5 cell f22 is 0.7 I have a table made across the top this is degrees this is where 24.5 would be along BP4:Cu4 It starts at <.5 degrees and goes up to 30 degrees although I do not have it in decimal points just whole numbers 1-2-3-4-5-6-7 etc In coulmn BP6:bp32 I have the other number I need to look up. It starts at 0.4 and ends at 3.0 In the cells BP4:CU 32 are the set values I need to lookup the set value of 0.7 in realationship with 24.5 degrees. I hope I have explained this correctly. Is this possible to do. To lookup two different values and return the set value. Thanks in adavance scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |