I have searched this and other boards for an answer. Hope you can help me
out, other answers do not exactly address my formula.
=LOOKUP(Form!C3,Assignments!A3:A194,Assignments!B3 :B194)
Where Form!C3 contains a franchise number the user types in. If the number
does NOT exist, I need to inform (i.e., a message box) the user that an
invalid number has been entered.

The nearest match is not an option for this form.

Thanks