Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1

Eliminate #N/A in Vlookup formulas

I need Vlookup to return a blank if there is no value to be found in the
table. IE: Vlookup,a2,"table",12,false returns #N/A if there is not exact
match in "table" (Another spreadsheet). How do I eliminate this? It's driving
me nuts!

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 Formulas	Gayle B	Excel Worksheet Functions	5	September 10th 09 07:38 AM
Vlookup with other formulas	John	Excel Worksheet Functions	1	January 7th 09 12:30 AM
vlookup formulas	smprfii	Excel Worksheet Functions	1	July 6th 07 01:30 AM
VLOOKUP formulas	Donna	Excel Worksheet Functions	4	July 9th 06 12:08 AM
Is there a way to eliminate specific cells from formulas?	Valerian	New Users to Excel	9	April 3rd 06 10:01 PM

All times are GMT +1. The time now is 03:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us