Do you need all 4, if there, or just the last one
This will find the item in the LAST filled column on row 1
=MATCH(999999,1:1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rahim" wrote in message
...
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