|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
December 13th, 2007, 11:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to remove #n/a error in excel vlookup b/c value is not found?
I'm using vlookup in excel to pull select data from a worksheet. The problem
is that the value I'm seeking isn't always in the table array. So, I get a #n/a error. The #n/a then prevents me from summing the data that I'm collecting using the vlookup. How do I make the #n/a go away or equal zero so I can sum the data? 
|
|
#2
December 13th, 2007, 11:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not found?
Try one of these:
Returns a blank: =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)) Returns a 0: =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....)) -- Biff Microsoft Excel MVP "B. Franklin Saunders" B. Franklin wrote in message ... I'm using vlookup in excel to pull select data from a worksheet. The problem is that the value I'm seeking isn't always in the table array. So, I get a #n/a error. The #n/a then prevents me from summing the data that I'm collecting using the vlookup. How do I make the #n/a go away or equal zero so I can sum the data?
|
|
#3
December 13th, 2007, 11:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
It worked. Thank you!!
"T. Valko" wrote: Try one of these: Returns a blank: =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)) Returns a 0: =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....)) -- Biff Microsoft Excel MVP "B. Franklin Saunders" B. Franklin wrote in message ... I'm using vlookup in excel to pull select data from a worksheet. The problem is that the value I'm seeking isn't always in the table array. So, I get a #n/a error. The #n/a then prevents me from summing the data that I'm collecting using the vlookup. How do I make the #n/a go away or equal zero so I can sum the data?
|
|
#4
December 14th, 2007, 03:07 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "B. Franklin Saunders" wrote in message ... It worked. Thank you!! "T. Valko" wrote: Try one of these: Returns a blank: =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)) Returns a 0: =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....)) -- Biff Microsoft Excel MVP "B. Franklin Saunders" B. Franklin wrote in message ... I'm using vlookup in excel to pull select data from a worksheet. The problem is that the value I'm seeking isn't always in the table array. So, I get a #n/a error. The #n/a then prevents me from summing the data that I'm collecting using the vlookup. How do I make the #n/a go away or equal zero so I can sum the data?
|
|
#5
May 20th, 2008, 03:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
Is this still true for Excel 2007? Because I tried the top one, and it still
left 0's in the column. "T. Valko" wrote: You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "B. Franklin Saunders" wrote in message ... It worked. Thank you!! "T. Valko" wrote: Try one of these: Returns a blank: =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)) Returns a 0: =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....)) -- Biff Microsoft Excel MVP "B. Franklin Saunders" B. Franklin wrote in message ... I'm using vlookup in excel to pull select data from a worksheet. The problem is that the value I'm seeking isn't always in the table array. So, I get a #n/a error. The #n/a then prevents me from summing the data that I'm collecting using the vlookup. How do I make the #n/a go away or equal zero so I can sum the data?
|
|
#6
May 20th, 2008, 05:00 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
Try using if(iserror(vlookup(Value,Table,column,0)),"your
response",(vlookup(Value,Table,column,0))) Hope that helps "zeilski" wrote: Is this still true for Excel 2007? Because I tried the top one, and it still left 0's in the column. "T. Valko" wrote: You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "B. Franklin Saunders" wrote in message ... It worked. Thank you!! "T. Valko" wrote: Try one of these: Returns a blank: =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)) Returns a 0: =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....)) -- Biff Microsoft Excel MVP "B. Franklin Saunders" B. Franklin wrote in message ... I'm using vlookup in excel to pull select data from a worksheet. The problem is that the value I'm seeking isn't always in the table array. So, I get a #n/a error. The #n/a then prevents me from summing the data that I'm collecting using the vlookup. How do I make the #n/a go away or equal zero so I can sum the data?
|
|
#7
May 27th, 2008, 10:34 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
When I add two VLOOKUP formulars with the adjust with the below "IF (ISNA)",
and one items of the two is found, Excel is not displaying the item found, but a Zero. What should I do? "T. Valko" wrote: Try one of these: Returns a blank: =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)) Returns a 0: =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....)) -- Biff Microsoft Excel MVP "B. Franklin Saunders" B. Franklin wrote in message ... I'm using vlookup in excel to pull select data from a worksheet. The problem is that the value I'm seeking isn't always in the table array. So, I get a #n/a error. The #n/a then prevents me from summing the data that I'm collecting using the vlookup. How do I make the #n/a go away or equal zero so I can sum the data?
|
|
#8
June 13th, 2008, 05:27 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
It worked fine using Excel 2007.
Thank you very much! "T. Valko" wrote: Try one of these: Returns a blank: =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)) Returns a 0: =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....)) -- Biff Microsoft Excel MVP "B. Franklin Saunders" B. Franklin wrote in message ... I'm using vlookup in excel to pull select data from a worksheet. The problem is that the value I'm seeking isn't always in the table array. So, I get a #n/a error. The #n/a then prevents me from summing the data that I'm collecting using the vlookup. How do I make the #n/a go away or equal zero so I can sum the data?
|
|
#9
June 13th, 2008, 06:33 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
If you're using Excel 2007 try one of these:
=IFERROR(VLOOKUP(.....),"") =IFERROR(VLOOKUP(.....),0) Note those will trap *all* errors, not just #N/A. -- Biff Microsoft Excel MVP "Ross" wrote in message ... It worked fine using Excel 2007. Thank you very much! "T. Valko" wrote: Try one of these: Returns a blank: =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)) Returns a 0: =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....)) -- Biff Microsoft Excel MVP "B. Franklin Saunders" B. Franklin wrote in message ... I'm using vlookup in excel to pull select data from a worksheet. The problem is that the value I'm seeking isn't always in the table array. So, I get a #n/a error. The #n/a then prevents me from summing the data that I'm collecting using the vlookup. How do I make the #n/a go away or equal zero so I can sum the data?
|
|
#10
June 24th, 2008, 08:45 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
Worked perfect for me. Just checked the help file to get to the discussion
groups.  "T. Valko" wrote: If you're using Excel 2007 try one of these: =IFERROR(VLOOKUP(.....),"") =IFERROR(VLOOKUP(.....),0) Note those will trap *all* errors, not just #N/A. -- Biff Microsoft Excel MVP "Ross" wrote in message ... It worked fine using Excel 2007. Thank you very much! "T. Valko" wrote: Try one of these: Returns a blank: =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)) Returns a 0: =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....)) -- Biff Microsoft Excel MVP "B. Franklin Saunders" B. Franklin wrote in message ... I'm using vlookup in excel to pull select data from a worksheet. The problem is that the value I'm seeking isn't always in the table array. So, I get a #n/a error. The #n/a then prevents me from summing the data that I'm collecting using the vlookup. How do I make the #n/a go away or equal zero so I can sum the data?
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
