Thread: Lookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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!