Hi Rahim

Try the below formula in cell A2
=INDEX(B2:D2,MATCH(TRUE,INDEX(B2:D2<0,),))

If this post helps click Yes
---------------
Jacob Skaria


"Rahim" wrote:

I have 4 stations , lets say A, B, C, D with daily Temperature Data, I want
fill up missinf data "M" for station A from stations B,C,D; if I write =if
(a2="M", b2, a2) to get datat from staion B, BUT station B may have missing
"M" so I need to get the data from station C for that particular date and
again if Station C has "M" for the same day I need to get it from station D.
so

should I write
=IF(D2="M",E2*(IF(E2="M",F2,E2),D2))

but this gives me result "FALSE", can anybody help me

I appreciate your help, thanks