Posted to microsoft.public.excel.misc

Richard

Posts: n/a

Vlookup returns a zero?

Hi,

I'm using vlookup to return a value, if there is one, from another
worksheet. The problem I'm encountering is that vlookup will return a zero if
there is no value to return. How do I get to return an empty cell if it
cannot find a value to return?

Thank You,

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 Function	Chris Manning	Excel Discussion (Misc queries)	2	June 2nd 05 10:26 PM
VLOOKUP with duplicate returns	dandigger	Excel Discussion (Misc queries)	4	January 28th 05 07:13 AM
vlookup data hidden within worksheet		Excel Worksheet Functions	0	January 26th 05 12:09 PM
Vlookup info being used without vlookup table attached?		Excel Worksheet Functions	0	January 25th 05 10:43 AM
Vlookup returns incorrect match	Smichaud	Excel Discussion (Misc queries)	2	November 30th 04 10:51 AM

All times are GMT +1. The time now is 06:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us