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 -