Guys, thanks for all your suggestions. I tried all solutions, and all
worked as requested. Although this isn't some coding contest, my vote
goes to Tony's suggestion.

cheers,
Jerry

acw wrote in message ...
Jerry

A UDF that may help.

Tony

Function checker(x As Range)
arr = Array("A", 1, "F", "G", "K", "T", 3, "W", "X")
Dim chkitems As Variant
chkitems = x.Value
checker = "Missing Items: "
For Each ce In arr
On Error GoTo errone
fred = WorksheetFunction.Match(ce, chkitems, 0)
Next ce

errone:
Select Case Err.Number
Case 1004
checker = checker & ce & ", "
End Select

Resume Next

End Function


----- Jerry wrote: -----

Hi all,

Is there a way to check a range for particular values that are
missing?
Suppose I have a list of possible values: A,1,F,G,K,T,3,W,X
And I have the following values in column C:

A
K
1
A
T
X
X
G

Ideally, I'd need a function that would return the following string:

"Missing items: F, 3, W"

The actual list has 20 possible values. My guess is that one should
work with arrays, but my experience with those is very limited. Could
this be solved with some VBA maybe?

thanks for your help,
Jerry