Have formula =if(a1=1,"1",if(b1=2","2")) in Column E. How do i drag the
formula to Columns F and G so that the formula changes show
=if(a2=1,"1",if(b2=2,"2")) in row F and =IF(a3=1,"1",if(b3=1"1")) in row G.

Currently if i drag the formula to another column in Row E, i get the
following result: =if(b1=1,"1",if(c1=2"2")) and =if(c1=1"1",if(d1=2,"2")).

Hope this makes sense!!
--
thanx