To shorten it a bit try using part of Bob's post where the values are in
{} so you don't have to type F2= for each one in the OR statement.

=IF(OR(F2={"A","B","C","D"}),"Active",IF(OR(F2={"E ","F","G"}),"Inactive",IF(OR(F2={"H","I","J"}),"Fu ture","Not
Found")))


Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=541644