=IF(ISNUMBER(SEARCH("farm",A2)),etc


--


Regards,


Peo Sjoblom



"Iguss" wrote in message
...
I have the following


FEDERAL FARM CR this is what I need FEDERAL FARM CREDIT BANK
FEDERAL HOME BKS this is what I need FEDERAL HOME LOAN BANK
FEDERAL NATL MTG this is what I need FEDERAL NATIONAL MORTGAGE CORP

=IF(A2="*FARM*","FEDERAL FARM CREDIT BANK",IF(A2="*HOME*","FEDERAL HOME
LOAN
BANK",IF(A2,"*NATL*","FEDERAL NATIONAL MORTGAGE CORPORATION","")))

Can you please advise why a following formula doesn't work and how can I
correct it.

Thank you