If Vlookup is error ( #NA)
in [Functions]
|
Prev: EXCEL COUNTING HELP
Next: Macro Help
From: Steve on 15 Mar 2010 16:36 I have this formula =IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)>0,(VLOOKUP(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
From: T. Valko on 15 Mar 2010 16:59 What version of Excel are you using? Try this... =IF(COUNTIF(data!$E$3:$E$16,RU!C3),IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,0)>0,VLOOKUP(RU!C3,data!$E$3:$R$16,2,0),""),"") -- Biff Microsoft Excel MVP "Steve" <Steve(a)discussions.microsoft.com> wrote in message news:C900AB0D-849F-4BA9-8309-5D76657ECA5D(a)microsoft.com... >I have this formula > =IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)>0,(VLOOKUP(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
From: L. Howard Kittle on 15 Mar 2010 16:58 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" <Steve(a)discussions.microsoft.com> wrote in message news:C900AB0D-849F-4BA9-8309-5D76657ECA5D(a)microsoft.com... >I have this formula > =IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)>0,(VLOOKUP(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
From: Steve on 16 Mar 2010 09:41 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!C3,data!$E$3:$R$16,2,0)>0,VLOOKUP(RU!C3,data!$E$3:$R$16,2,0),""),"") > > -- > Biff > Microsoft Excel MVP > > > "Steve" <Steve(a)discussions.microsoft.com> wrote in message > news:C900AB0D-849F-4BA9-8309-5D76657ECA5D(a)microsoft.com... > >I have this formula > > =IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)>0,(VLOOKUP(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 > > > . >
From: Steve on 16 Mar 2010 09:43
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" <Steve(a)discussions.microsoft.com> wrote in message > news:C900AB0D-849F-4BA9-8309-5D76657ECA5D(a)microsoft.com... > >I have this formula > > =IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)>0,(VLOOKUP(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 > > > . > |