Hi Joel, it,s working if the content of C10 is entered manually. But the
content of C10 is given by a formula. In my table, C10 is in fact H8.
Formula in H8 is given by this formula : =HLOOKUP(H7,rate!E7:AC8,2,FALSE)
And this is your formula adjusted to my table : =OFFSET(rate!E8,0,2*H8-1,1,1)
Can your code ignore the formula in H8 and see only what is displayed?
Thanks!

"Joel" wrote:

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!