BenjieLop Wrote:
Try this ...

=IF(A4=\"APTFEE\",\"ASC31\",IF(A4=\"R30EE\",\"RCT3 1\",\"FALSE\"))

OR, if there are only 2 choices for A4, i.e, either it is "Aptfee" or
"r30ee" then your formula can be

=IF(A4=\"APTFEE\",\"ASC31\",\"RCT31\")

Regards.


thanks

that 1st one did the job, perfect
i knew i shouldve came here first.
Thanks again
Pajo


--
pajodublin
------------------------------------------------------------------------
pajodublin's Profile: http://www.excelforum.com/member.php...fo&userid=2804
View this thread: http://www.excelforum.com/showthread...hreadid=477026