Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 1st 09, 05:12 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
Posts: 1
Default 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!

  #2   Report Post  
Old June 1st 09, 05:19 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default Eliminate #N/A in Vlookup formulas

One way:

=IF(ISNA(VLOOKUP(A2,Table,12,0)),"",VLOOKUP(A2,Tab le,12,0))

--
Biff
Microsoft Excel MVP


"kkeim" wrote in message
...
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!



  #3   Report Post  
Old June 1st 09, 05:21 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default Eliminate #N/A in Vlookup formulas

Hi
=iferror(Vlookup,a2,"table",12,false ),"")

if this helps please click yes

"kkeim" wrote:

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!

  #4   Report Post  
Old June 1st 09, 05:25 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default Eliminate #N/A in Vlookup formulas

Hi,
if you are using excel 2003 use

=IF(ISERROR(VLOOKUP(A3,Sheet2!A:B,2,FALSE)),"",VLO OKUP(A3,Sheet2!A:B,2,FALSE))

"Eduardo" wrote:

Hi
=iferror(Vlookup,a2,"table",12,false ),"")

if this helps please click yes

"kkeim" wrote:

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!

  #5   Report Post  
Old June 1st 09, 05:30 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 120
Default Eliminate #N/A in Vlookup formulas

try the traditional formula

=IF(ISNA(VLOOKUP(A2,"table",12,0)),"",VLOOKUP(A2," table",12,0))

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"kkeim" wrote:

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017