Showing an empty cell instead of "#N/A" ?

[LucidCheetah]

I am using vlookup to populate cells in one column of my sheet, but when I have no value in the C column to draw from, the B column displays "#N/A". How can I modify this line to show an empty cell until I have input my value into the C column?

=VLOOKUP(C2,'Sheet2'!$A$1:$B$2662,2,0)

 

[Eric W]

If you have Excel 2007 or newer:

=IFERROR(VLOOKUP(C2,'Sheet2'!$A$1:$B$2662,2,0),"")

 

[Crazy Dazz]

If you have Excel 2007 or newer:

=IFERROR(VLOOKUP(C2,'Sheet2'!$A$1:$B$2662,2,0),"")

Eric is correct.

On the offchance you are stuck with an older version of Excel, you could use something like this:

=IF(ISERROR(VLOOKUP(C2,'Sheet2'!$A$1:$B$2662,2,0)),"",VLOOKUP(C2,'Sheet2'!$A$1:$B$2662,2,0))

 

[LucidCheetah]

If you have Excel 2007 or newer:

=IFERROR(VLOOKUP(C2,'Sheet2'!$A$1:$B$2662,2,0),"")

Thanks! I figured it was something along thos elines from my Googling, but I kept putting an extra "=" in front of vlookup in the brackets and couldn't figure out what i was doing wrong! Thanks again.

 

[mrhstn]

If you have Excel 2013 or newer you can switch out IFERROR for IFNA. It will only trap #N/A errors, so things such as #REF will still flag.