Hi everyone, I have something similar to the following table (but much larger) and I need to get specific values, based on info entered in other range:
________________________________________________
│ 1 │ 2 │ 3 │ 4 │
________________________________________________
a │ 2.5 │ 2.6 │ 2.7 │ 2.8 │
________________________________________________
b │ 3.5 │ 3.6 │ 3.7 │ 3.8 │
________________________________________________
c │ 4.5 │ 5.6 │ 6.7 │ 7.8 │
________________________________________________
d │ 5.5 │ 6.6 │ 7.7 │ 8.8 │
________________________________________________
For example, I have two other cells separated from the table showing "b" and "2".. so I need to get the result 3.6 in a third cell... how can I do this??
Thank you!!
Bookmarks