Menu

Vlookup and Values

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.worksheet.functions

Dave Peterson Dave Peterson is offline

Dave Peterson is offline

external usenet poster

Posts: 35,218

Default

Vlookup and Values

=if(vlookup()="","",vlookup())

wrote:

When using vlookup - if the column is empty, I receive a value of "0"
in some cells (I assume this is due to the type of data in the cell),
but I would rather receive a "blank" cell. How do I modify the vlookup
calculation to return a blank if the originating cell is blank?
Thanks

--

Dave Peterson

Reply With Quote

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 stops working with pasted values	SueD	Excel Worksheet Functions	6	May 23rd 06 11:45 AM
vlookup using two lookup values?	tjb	Excel Worksheet Functions	10	November 25th 05 05:21 AM
vlookup, multiple values, sum values into one cell??	Phillips L	Excel Worksheet Functions	4	November 9th 05 12:31 AM
How can I use the vlookup function to return a sum of the values?	Chaandni	Excel Discussion (Misc queries)	4	November 7th 05 03:05 PM
VLookup to sum cell values	Zakynthos	Excel Worksheet Functions	4	July 26th 05 12:05 PM

All times are GMT +1. The time now is 09:54 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement