Posted to microsoft.public.excel.misc

tom

external usenet poster

Posts: 570

Lookup Question

I see that when using the lookup function, if the lookup value entered does
not match anything in the lookup vector, the result vector returns as the
next lowest value. Is there any way to change that so that if there is no
match you get a #VALUE! result instead, or something other than the next
lowest value?

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
Lookup question	steve_m	Excel Discussion (Misc queries)	5	November 6th 08 01:41 PM
LOOKUP Question	WLMPilot	Excel Discussion (Misc queries)	4	December 5th 07 12:56 AM
Lookup Question	jam	Excel Worksheet Functions	3	July 2nd 06 11:58 AM
Lookup question	rk0909	Excel Discussion (Misc queries)	1	May 24th 06 07:26 PM
Lookup Question	Mackay 1979	Excel Worksheet Functions	2	February 19th 05 01:11 PM

All times are GMT +1. The time now is 03:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us