Named Range in an IF statement

[budifb]

I want to use a named range in an if statement so that if a value in a cell (L2) equals any value in the named range "status," then it returns a value from another cell (G2), if not then blank. However, I can't seem to figure out how exactly to put it....I did an equal sign but that doesn't work.

=IF(AND(AM2<>" ",L2=status),G2," ")

below is my named range in A1:A3
A1 I
A2 U
A3 L

Please help! Thanks so much!

 

[VoG]

Try

=IF(AND(AM2<>" ",ISNUMBER(MATCH(L2,status,0))),G2," ")

 

[budifb]

Thank you!