A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

If Vlookup is error ( #NA)



 
 
Thread Tools Display Modes
  #1  
Old March 15th, 2010, 09:36 PM posted to microsoft.public.excel.worksheet.functions
Steve
external usenet poster
 
Posts: 2,662
Default 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
  #2  
Old March 15th, 2010, 09:58 PM posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle
external usenet poster
 
Posts: 516
Default If Vlookup is error ( #NA)

Maybe this, but not completely sure.

=IF(ISERROR(VLOOKUP([RU]Sheet1!C3,data!$E$3:$R$16,2,FALSE)),0,((VLOOKUP([RU]Sheet1!C3,data!$E$3:$R$16,2,FALSE))))

HTH
Regards,
Howard

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



  #3  
Old March 15th, 2010, 09:59 PM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default If Vlookup is error ( #NA)

What version of Excel are you using?

Try this...

=IF(COUNTIF(data!$E$3:$E$16,RU!C3),IF(VLOOKUP(RU!C 3,data!$E$3:$R$16,2,0)0,VLOOKUP(RU!C3,data!$E$3:$ R$16,2,0),""),"")

--
Biff
Microsoft Excel MVP


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



  #4  
Old March 16th, 2010, 02:41 PM posted to microsoft.public.excel.worksheet.functions
Steve
external usenet poster
 
Posts: 2,662
Default If Vlookup is error ( #NA)

Worked great. Thank you.

And I do have version 2003.

Steve

"T. Valko" wrote:

What version of Excel are you using?

Try this...

=IF(COUNTIF(data!$E$3:$E$16,RU!C3),IF(VLOOKUP(RU!C 3,data!$E$3:$R$16,2,0)0,VLOOKUP(RU!C3,data!$E$3:$ R$16,2,0),""),"")

--
Biff
Microsoft Excel MVP


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



.

  #5  
Old March 16th, 2010, 02:43 PM posted to microsoft.public.excel.worksheet.functions
Steve
external usenet poster
 
Posts: 2,662
Default If Vlookup is error ( #NA)

As written, it was producing zeros instead of blanks, but by changing the
,0, to ,"",
It worked as I wanted.

Thanks again,

Steve

"L. Howard Kittle" wrote:

Maybe this, but not completely sure.

=IF(ISERROR(VLOOKUP([RU]Sheet1!C3,data!$E$3:$R$16,2,FALSE)),0,((VLOOKUP([RU]Sheet1!C3,data!$E$3:$R$16,2,FALSE))))

HTH
Regards,
Howard

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



.

  #6  
Old March 16th, 2010, 05:07 PM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default If Vlookup is error ( #NA)

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Worked great. Thank you.

And I do have version 2003.

Steve

"T. Valko" wrote:

What version of Excel are you using?

Try this...

=IF(COUNTIF(data!$E$3:$E$16,RU!C3),IF(VLOOKUP(RU!C 3,data!$E$3:$R$16,2,0)0,VLOOKUP(RU!C3,data!$E$3:$ R$16,2,0),""),"")

--
Biff
Microsoft Excel MVP


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



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.