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

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

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

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


.

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


.

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


.