Lookup
Works great!
Thanks!
"Jacob Skaria" wrote:
Try
=INDEX($A$1:$L$1,MATCH(C10,$A$1:$L$1,0)+1)
If this post helps click Yes
---------------
Jacob Skaria
"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!
|