Hi,
Im trying to use 2 IF functions on the one cell.

My jobs consists of alot of printing with numerous types of paper each
numbered differently. Jobs that come in are all named differently and
use different forms. for example. the Job APTFEE uses ASC31 stationary,
whereas job R30EE uses RCT31 stationary.

Im trying to set up a form so when someone types in the job name the
type of paper will appear in the cell. I hope im making sense.

this is the formula ive been using, and changing it around for the last
4 hours without success...
=IF(A4="Aptfee","ASC31","False")OR(=IF,A4="r30ee", "RCT31","False")

Ive tried alot of different ones this one is just the current one ive
tried and i probably was closer before, any help would be much
appreciated
Thanks
Pajodublin


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