Posted to microsoft.public.excel.worksheet.functions

Steve

external usenet poster

Posts: 1,814

If Vlookup is error ( #NA)

I have this formula
=IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)0,(VLOO KUP(RU!C3,data!$E$3:$R$16,2,FALSE)),"")

that is producing #NA if it doesn't find C3. I would instead like the result
to be blank "" when it produces an #NA

Thanks,

Steve

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 error	Alfredo Martinez	Excel Discussion (Misc queries)	2	October 28th 08 04:46 AM
vlookup error	Vlookup not accurate	Excel Discussion (Misc queries)	0	October 4th 06 06:21 PM
vlookup error	Jim	Excel Worksheet Functions	1	January 25th 06 08:49 PM
Value Not Available Error in Vlookup	thefeokas	Excel Discussion (Misc queries)	3	April 14th 05 05:57 PM
#N/A error with VLOOKUP	Michelle Tucker	Excel Discussion (Misc queries)	4	December 14th 04 01:23 PM

All times are GMT +1. The time now is 01:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us