=IF(COUNTIF(Assignments!A3:A194,Form!
C3),your_formula_here,"Invalid Number")

HTH
Jason
Atlanta, GA

-----Original Message-----
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!B 3: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


.