FIND is case sensitive, you may be better off with SEARCH:

=IF(AND(ISNUMBER(SEARCH({"FHA","VA"},O2))),"someth ing","something else")

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Derek Y via OfficeKB.com" wrote in message
...

YAY I GOT IT....

=IF(AND(ISNUMBER(FIND("FHA",O2)),ISNUMBER(FIND("VA ",O2))),"something",
"something else")

thanks anyways


--
Message posted via http://www.officekb.com