list of ID#'s on Sheet2, A1:A100

=IF(ISNUMBER(MATCH(A1,'Sheet2'!A1:A100)),"Found ID","ID not found")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"TKD" wrote:

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!