One way...

=IF(G11="","",IF(COUNTIF(G11,"*FHA*"),"FHA","Conv" ))

--
Biff
Microsoft Excel MVP


"scottay" wrote in message
...
I am trying to do a formula that searches a cell for the letters "FHA" then
the result is FHA. If the cell contains anything other than "FHA" then
the
result is Conv. If the cell is blank then result in blank.
=IF(ISNUMBER(SEARCH("FHA",G11)),"Gov", "Conv")

Thanks for your help.