IF(ISTEXT nested statement - Please Help

Hi everyone,

I have creaqted the IF(ISTEXT nested statement below, but when I use it I get one value in return. Can you please check what I am doing wrong? Here is the statemet:

=IF(ISTEXT(SEARCH("Transporter",L2)),"Validation Request",IF(ISTEXT(SEARCH("DVA",L2)),"Entitlement Request",IF(ISTEXT(SEARCH("Screen Saver Lockdown",L2)),"Exception Request",IF(ISTEXT(SEARCH("MF Account Creation via NGP",L2)),"Entitlement Request",IF(ISTEXT(SEARCH("Guest - WiFi Bulk",L2)),"Exception Request",IF(ISTEXT(SEARCH("QIP",L2)),"Entitlement Request",IF(ISTEXT(SEARCH("ITSec-PSO Privileged Entitlements",L2)),"Entitlement Request",IF(ISTEXT(SEARCH("UnixOps-PA",L2)),"PA Request",IF(ISTEXT(SEARCH("Guest Wireless Sponsor Req",L2)),"PA Request",IF(ISTEXT(SEARCH("Windows PA",L2)),"PA Request",IF(ISTEXT(SEARCH("BatchID Req",L2)),"Entitlement Request",IF(ISTEXT(SEARCH("Discovery Data Access Req",L2)),"Entitlement Request",IF(ISTEXT(SEARCH("EMP Generated MF Entitlements",L2)),"Entitlement Request",IF(ISTEXT(SEARCH("PA Req",L2)),"PA Request",IF(ISTEXT(SEARCH("Ref Tbl Update via NGP",L2)),"Entitlement Request",IF(ISTEXT(SEARCH("TSS MF-User Acct Maintenance",L2)),"Entitlement Request",IF(ISTEXT(SEARCH("WebSite Access",L2)),"Exception Request",IF(ISTEXT(SEARCH("Validation Task",L2)),"Validation Request","Generic"))))))))))))))))))

The results is always Generic.

Why not upload the spreadsheet?

I cannot upload the file, for security reasons.
This is on Excel 2007

Thanks, it worked...

Thanks this works too!