Have the following forumla;

=IF(AND(A2="C/FWD",A3=1),A3,0)

but also want to return the value in A3 if A3 = 2, 3, 4, 5 etc....

Any ideas?

Thanks


--
ExcelBob
------------------------------------------------------------------------
ExcelBob's Profile: http://www.excelforum.com/member.php...o&userid=34152
View this thread: http://www.excelforum.com/showthread...hreadid=539203