JFeeman

Posts: n/a

Lookup returns message box when an exact match is not found

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup returns incorrect match	Smichaud	Excel Discussion (Misc queries)	2	November 30th 04 10:51 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
LookUp - Exact only	Desparate	Excel Worksheet Functions	2	November 11th 04 09:52 AM
LookUp - Exact only	Desparate	Excel Worksheet Functions	1	November 11th 04 09:45 AM
Find a match that;s not exact	Phyllis	Excel Worksheet Functions	0	November 8th 04 08:12 PM

All times are GMT +1. The time now is 04:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us