Find a value with a list of values

[jeffmb]

Is there a function similar to SQL where I can see if a value is within a list of values, such as:

ValA in ("abc","def","ghi")

 

[VoG]

Is this in a formula or VBA?

 

[jeffmb]

Sorry. I should have stated that this is in VBA.

 

[VoG]

Try like this

If IsNumeric(Application.Match(Range("A1").Value, Array("abc", "def", "ghi"), 0)) Then
'
'match found
'
Else
'
'no match
'
End If

 

[jeffmb]

That worked. Thanks.