James

Posts: n/a

VLOOKUP can have a zero or a one at the end - if you have a one it will look
for the closest match so may return values even if there are no matches. If
you use a zero it will only return a value if there is an exact match. eg.

VLOOKUP(A1,D1:E6,1,0)

J

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
Need help with modifying VLookUp	Tom	Excel Discussion (Misc queries)	4	December 2nd 04 12:44 AM
VLOOKUP help	SamUK	Excel Worksheet Functions	8	November 22nd 04 12:27 AM
carrying a hyper link when using the vlookup function	mike	Excel Worksheet Functions	1	November 19th 04 03:49 AM
VLOOKUP not working	Scott	Excel Worksheet Functions	3	November 12th 04 08:06 PM
vlookup.	Amit	Excel Worksheet Functions	2	November 3rd 04 12:34 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us