View Single Post
  #1   Report Post  
nemesis2
 
Posts: n/a
Default lookup two values

I have the following

Size Depth Lenght
24 2 4
24 3 6
24 4 8
30 2 10

Cell A1 = 24, Cell B1 = 3. I want the result on C1 to be 6. What would be
the formula?