Help with excel function
 

Hello,
I need some help with a function in excel so pls if someone knows how
I'd really appreciate the help.
So here goes, I'll try to explain it the best i can:


E | F | G | ... | O |
| 1 | ... | 9 |
7| 24.5 | | 36 | ... | 74 |



What I'm looking for is a function that will search for a given
text (for example 24.5) and return one of the values from this row
from G-O columns on the same row based on the number entered in
another cell (numbers 1-9).
I guess the part with the G-O columns can be done with select case
and i saw several examples of how to search for a text in a number of
cells but I've no idea how to link the search to return the data from
G-O columns.

Thanks in advance.

Help with excel function
 

=IF(E2=24.5,OFFSET(F2,,D2),"")

D2=7



On 8 Kwi, 17:28, wrote:
Hello,
I need some help with a function in excel so pls if someone knows how
I'd really appreciate the help.
So here goes, I'll try to explain it the best i can:

* * * * *E * * *| * *F * | * * * * G * *| *... | * O * |
* * * * * * * * * * * * * *| * * * *1 * * *| *... *| * 9 * |
7| * * 24.5 * | * * * * *| * * * 36 * * | *.... *| * *74 |

* * What I'm looking for is a function that will search for a given
text (for example 24.5) * and return one of the values from this row
from G-O columns on the same row based on the number entered in
another cell (numbers 1-9).
* * I guess the part with the G-O columns can be done with select case
and i saw several examples of how to search for a text in a number of
cells but I've no idea how to link the search to return the data from
G-O columns.

Thanks in advance.

Help with excel function
 

On Apr 8, 7:16*pm, Jarek Kujawa wrote:
=IF(E2=24.5,OFFSET(F2,,D2),"")

D2=7


Thanks Jarek, but the thing is that i need to search the entire E
column for that text (24.5 for example) and the cells in E column
might contain data like "24.5, 26.7, 22".
I'll be really grateful if you can help me with that little detail.

Help with excel function
 

=OFFSET($E$1,MATCH(24.5,$E$1:$E$1000,1)-1,D2)

adjust $E$1:$E$1000 to suit

pls click YES if this post helped you



On 8 Kwi, 19:10, wrote:
On Apr 8, 7:16*pm, Jarek Kujawa wrote:

=IF(E2=24.5,OFFSET(F2,,D2),"")

D2=7

Thanks Jarek, but the thing is that i need to search the entire E
column for that text (24.5 for example) and the cells in E column
might contain data like "24.5, 26.7, 22".
*I'll be really grateful if you can help me with that little detail.

Help with excel function
 

thanks much for your stars, Georgi
;-)

On 8 Kwi, 19:36, Jarek Kujawa wrote:
=OFFSET($E$1,MATCH(24.5,$E$1:$E$1000,1)-1,D2)

adjust $E$1:$E$1000 to suit

pls click YES if this post helped you

On 8 Kwi, 19:10, wrote:



On Apr 8, 7:16*pm, Jarek Kujawa wrote:

=IF(E2=24.5,OFFSET(F2,,D2),"")

D2=7

Thanks Jarek, but the thing is that i need to search the entire E
column for that text (24.5 for example) and the cells in E column
might contain data like "24.5, 26.7, 22".
*I'll be really grateful if you can help me with that little detail.- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -