Ignore formula if cell is blank

[lray801]

Hi folks,

I have a formula: =VLOOKUP(J8,'Expense Description'!$A$2:$B$29,2,FALSE). When this formula looks at J8 and it's blank, it errors out. I know that there's a way to ignore the formula if there's an error (perhaps with iferror or iserror?), but I don't know the syntax. Since you're all much smarter than I am at Excel, here I am!

Thanks for the help,
Luke

 

[NeonRedSharpie]

=IFERROR(VLOOKUP(J8,'Expense Description'!$A$2:$B$29,2,FALSE),"")

 

[jduley]

=IFERROR(VLOOKUP(J8,'Expense Description'!$A$2:$B$29,2,FALSE),"")

 

[lray801]

=IFERROR(VLOOKUP(J8,'Expense Description'!$A$2:$B$29,2,FALSE),"")</pre>

So simple yet..... Thank you so very much, both of you!