If value, then display underneath value
 

Hi, i have in C10 a value. This value is changing I need a code to look in
C10, see what is in this cell, and to search for that value in A1:L1, and if
it finds C10 value, then to display content from underneath cell.
Ex:
A B C ...... L
01.01.2009 01.02.2009 01.03.2009
153/01.01.2009 238/01.02.2009 542/01.03.2009

If in C10 is 01.02.2009, then to display 238/01.02.200.
Something like :If(indirect(C10), A1:L1, then display match(A2:L2)
If the code finds C10 value in A1:L1, then to display content of
correspondind underneath cell.
In A2:L2, i have something like this : 238/01.02.2009, so i need to retrieve
"number, slash, date"
Can this be done?
Thanks!

If value, then display underneath value
 

Hi,

=HLOOKUP(C10,A1:L2,2,FALSE)

Mike

"puiuluipui" wrote:

Hi, i have in C10 a value. This value is changing I need a code to look in
C10, see what is in this cell, and to search for that value in A1:L1, and if
it finds C10 value, then to display content from underneath cell.
Ex:
A B C ...... L
01.01.2009 01.02.2009 01.03.2009
153/01.01.2009 238/01.02.2009 542/01.03.2009

If in C10 is 01.02.2009, then to display 238/01.02.200.
Something like :If(indirect(C10), A1:L1, then display match(A2:L2)
If the code finds C10 value in A1:L1, then to display content of
correspondind underneath cell.
In A2:L2, i have something like this : 238/01.02.2009, so i need to retrieve
"number, slash, date"
Can this be done?
Thanks!

If value, then display underneath value
 

Hi Mike, it's not working. I get #REF!
And i need the cell below. I think your code retrieve the cell to the right.
Thanks!

"Mike H" wrote:

Hi,

=HLOOKUP(C10,A1:L2,2,FALSE)

Mike

"puiuluipui" wrote:

Hi, i have in C10 a value. This value is changing I need a code to look in
C10, see what is in this cell, and to search for that value in A1:L1, and if
it finds C10 value, then to display content from underneath cell.
Ex:
A B C ...... L
01.01.2009 01.02.2009 01.03.2009
153/01.01.2009 238/01.02.2009 542/01.03.2009

If in C10 is 01.02.2009, then to display 238/01.02.200.
Something like :If(indirect(C10), A1:L1, then display match(A2:L2)
If the code finds C10 value in A1:L1, then to display content of
correspondind underneath cell.
In A2:L2, i have something like this : 238/01.02.2009, so i need to retrieve
"number, slash, date"
Can this be done?
Thanks!

If value, then display underneath value
 

Hi Mike, my mistake, it's working.
Thanks!

"Mike H" wrote:

Hi,

=HLOOKUP(C10,A1:L2,2,FALSE)

Mike

"puiuluipui" wrote:

Hi, i have in C10 a value. This value is changing I need a code to look in
C10, see what is in this cell, and to search for that value in A1:L1, and if
it finds C10 value, then to display content from underneath cell.
Ex:
A B C ...... L
01.01.2009 01.02.2009 01.03.2009
153/01.01.2009 238/01.02.2009 542/01.03.2009

If in C10 is 01.02.2009, then to display 238/01.02.200.
Something like :If(indirect(C10), A1:L1, then display match(A2:L2)
If the code finds C10 value in A1:L1, then to display content of
correspondind underneath cell.
In A2:L2, i have something like this : 238/01.02.2009, so i need to retrieve
"number, slash, date"
Can this be done?
Thanks!