| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table, display a value underneath another value in the values zone. | Excel Discussion (Misc queries) | |||
| annotation underneath a title | Charts and Charting in Excel | |||
| Need to fix macro to list data underneath each other | Excel Worksheet Functions | |||
| Checkbox value displays as text on the cell underneath it | Excel Discussion (Misc queries) | |||
| How do I shade the area underneath a curve | Excel Discussion (Misc queries) | |||
Hybrid Mode
