Posted to microsoft.public.excel.misc

njuneardave

Posts: n/a

question about excessive code in replacing #N/A when using VLOOKUP

so....here is the common consensus of the code to replace the #N/A VLOOKUP
result with a blank space:

=if(isna(vlookup(...),"",vlookup())

Why can't you simplify that code to look like this:

=if(isna(vlookup(...),"",Sheet1!A3)

assuming the A3 cell of Sheet1 is the search key.

What is wrong with simplifying the code to say that instead of copying the
vlookup method call again?

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 question	Brian	Excel Discussion (Misc queries)	1	April 18th 06 03:31 AM
VLOOKUP change question	roger_home	Excel Discussion (Misc queries)	6	February 25th 06 11:06 PM
question about vlookup	²ÓBear	Excel Worksheet Functions	2	December 14th 04 05:09 PM
Vlookup Question	Jeff	Excel Discussion (Misc queries)	2	December 2nd 04 02:40 PM
vlookup question	Alex	Excel Worksheet Functions	2	November 11th 04 05:11 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us