|
| 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 |
|
#11
August 26th, 2008, 01:05 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to remove #n/a error in excel vlookup b/c value is not fou
G888 . I got it..thanks for your formula yaarr...
"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? 
|
|
#12
August 26th, 2008, 06:50 PM
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!
-- Biff Microsoft Excel MVP "venumadhav g" wrote in message ... G888 . I got it..thanks for your formula yaarr... "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?
|
|
#13
September 14th, 2008, 05:58 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
thank you ver much for your information realy helpful!!!
"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?
|
|
#14
September 14th, 2008, 08:17 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 "SayedMe" wrote in message ... thank you ver much for your information realy helpful!!! "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?
|
|
#15
November 19th, 2008, 02:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
I am relatively new to entering formulas in an excel spreadsheet. I am
trying to remove the '#N/A' error & can't get any of the solutions suggested to work. Here is my formula: =((+K12-I12+1)*N12/LOOKUP(P12,S101:S105,T101:T105)) I cannot get the "IF(ISNA' to work. What am I missing? Thank you. "T. Valko" wrote: You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "SayedMe" wrote in message ... thank you ver much for your information realy helpful!!! "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?
|
|
#16
November 19th, 2008, 02:42 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
Try
=IF(ISNA(LOOKUP(P12,S101:S105,T101:T105)),"", (+K12-I12+1)*N12/LOOKUP(P12,S101:S105,T101:T105)) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "mollyk" wrote in message ... I am relatively new to entering formulas in an excel spreadsheet. I am trying to remove the '#N/A' error & can't get any of the solutions suggested to work. Here is my formula: =((+K12-I12+1)*N12/LOOKUP(P12,S101:S105,T101:T105)) I cannot get the "IF(ISNA' to work. What am I missing? Thank you. "T. Valko" wrote: You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "SayedMe" wrote in message ... thank you ver much for your information realy helpful!!! "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?
|
|
#17
January 4th, 2010, 07:42 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
I also wantd to thank T. Valko for the post of the ISNA answer it also helped
me in solving the Vlookup issue of #N/A. "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?
|
|
#18
January 4th, 2010, 11:55 PM
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 "msudog90" wrote in message ... I also wantd to thank T. Valko for the post of the ISNA answer it also helped me in solving the Vlookup issue of #N/A. "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?
|
|
#19
May 5th, 2010, 07:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to remove #n/a error in excel vlookup b/c value is not fou
Thank you- this was great!!
"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
