Thread: Lookup help!!
View Single Post
  #1   Report Post  
scott45
 
Posts: n/a
Default Lookup help!!

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