I want to be able to enter a value (an ID#) on sheet 1 of workbook (say, A1)
and compare to a list of ID#'s on another sheet, returning one message if it
matches and another if it is not found.

I have tried Vlookup but does not seem to work when data entering a value.
Thoughts?

thanks!