Posted to microsoft.public.excel.worksheet.functions

Todd F.

Posts: n/a

getting ride of #n/a result from vlookup

How does one best do away with the #n/a symbol when that is what the vlookup
returns

Is there a way to tell it to return "blank" or a designated value when the
voolkup does not come up with an exact match

note always use "false" - exact match.

Hey I appreciate your time

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
VBA	Monty	Excel Worksheet Functions	2	January 30th 06 01:37 PM
spell number	JAWAD CHOHAN	Excel Worksheet Functions	1	December 12th 05 05:58 PM
I NEED HELP with the SPELLNUMBER Function	vag	Excel Worksheet Functions	0	June 21st 05 08:17 AM
EXCEL:NUMBER TO GREEK WORDS	vag	Excel Worksheet Functions	1	June 15th 05 05:57 PM
Convert Numeric into Text	Monty	Excel Worksheet Functions	0	December 18th 04 09:25 PM

All times are GMT +1. The time now is 10:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us