Prev: EXCEL COUNTING HELPNext: 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" 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" 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" 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" 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 > > > . >  |  Next  |  Last Pages: 1 2 Prev: EXCEL COUNTING HELPNext: Macro Help