Lookup
You are looking for the column that is twice the input
input column
1 2
2 4
3 6
4 8
=OFFSET(A1,0,2*C10-1,1,1)
"puiuluipui" wrote:
Hi, i need to search the content of C10 in range A1:L1, and to display next
cell content.
Ex:
A1 B1 C1 D1 E1 F1 G1 H1
1 222 2 333 3 444 5 555.....
C10= 3
The formula to display 444
If C10=1, formula to display 222
Something like (A1:L1,C10 content +1)
Can this be done?
Thanks!
|