HI Guys

Can somebody show me how to do this simple if statement.

say i have two rows A and B

row A has a set of names in like peter, dan, simon etc etc

and

Row B also has a set of names in like peter, dan, simon etc etc

In row C i would like to write a formula like this:

if (RowA = RowB) print RowA Else Print RowB
can anyone help

Cheers in advance


--
digital21st
------------------------------------------------------------------------
digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=567462