Iferror

[sburkhar]

What am i doing wrong? I keep getting NAME? as an answer.

IFERROR(VLOOKUP(F12,'[VLOOKUP.xls]0-39999 (2)'!$B:$C,2,FALSE),"")

 

[MrKowz]

What version of Excel are you using?

 

[sburkhar]

I created it originally in 2007, but now i have to go back to 2003 so the analysts can use it.

 

[MrKowz]

Sadly, 2003 does not have support for IFERROR. You can, however, still use the alternative IF(ISERROR( function:

=IF(ISERROR(VLOOKUP(F12,'[VLOOKUP.xls]0-39999 (2)'!$B:$C,2,FALSE)),"",VLOOKUP(F12,'[VLOOKUP.xls]0-39999 (2)'!$B:$C,2,FALSE))

 

[sburkhar]

holy crap!!! that's a long function! I'll give it a try. I've been staring at and re-writing the other one for 2 hours now. Really wish i'd written you sooner.

 

[MrKowz]

The function isn't as bad as it seems. It first tests to see if your vlookup errors. If it does, then it returns blank, else it returns your vlookup:

To simplify it:

=IF(ISERROR(*your vlookup*),"",*your vlookup*)

 

[sburkhar]

thank you. I'll try this. I have another one to write on another tab. You might be hearing from me again in a few. I won't keep trying for 2 hours again.
thanks again!

 

[sburkhar]

I'm using the IS(ERROR) formula that you gave me which is working great, but now I'm getting #VALUE in my totals column. The 2 columns containing the IS(ERROR) formula have green smart tags in the corner that are indicating an Unprotected formula, but nothing I do in the smart tag is getting rid of #VALUE.
My totals column has a formula in it that has been working for years and I have not touched this column, so my problem is stemming from the changes I made with the VLOOKUP.

 

[MrKowz]

Can you please post that formula? Also, can you please post one of the IF(ISERROR( formulas you are using?

 

[sburkhar]

=IF(ISERROR(VLOOKUP('MAT PAGE'!F12,'https://www.ynaconnection.com/sites/dcbu_finpricpriv/Pricing%20Guidlines/[VLOOKUP.xls]0-39999 (2)'!$B$1:$J$65536,9,FALSE)),"",VLOOKUP('MAT PAGE'!F12,'https://www.ynaconnection.com/sites/dcbu_finpricpriv/Pricing%20Guidlines/[VLOOKUP.xls]0-39999 (2)'!$B$1:$J$65536,9,FALSE))


TOTALS FORMULA:
=ROUND((H6+I6+T6+U6)+ROUND((((L6+X6)/60)*INFO!$C$10),4),4)

Is it because my VLOOKUP is being pulled from another document?