Your welcome and thanks for the feedback

"puiuluipui" wrote:

Works great!
Thanks!

"Mike H" wrote:

Hi,

= OFFSET(A1,0,MATCH(C10,A1:L1,0))

Mike

"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!