With Description in A1 try the below formula in B1

This is based on keyword search. If keywords like Bachelor or degree is
present the formula returns AA+. You can add more keywords to suit your
requirement

=IF(A1<"",IF(COUNT(SEARCH({"Bachelor","Degree"},A 1)),"AA+","No Degree"),"")

If this post helps click Yes
---------------
Jacob Skaria


"AA+" wrote:

How do I return the value of Cell A2 as AA+ or No Degree in Cell B2?


Highest Education Level Description AA+ or No Degree
G-Bachelor's Level Degree AA+
C-HS Graduate No Degree