Using the If and Vlookup together

[chowman007]

Created a worksheet to report broken equipment that need repair. My problem is that "n/a" appears on the sheet when no data is input. I created this formula and works but when data is input it displays "n/a". What am I doing wrong?
=if(e473>" ",VLOOKUP(E473,VLOOKUP!$C$3:$M$104,2,0),"")

 

[VoG]

Try

=IF(E473<>"",VLOOKUP(E473,VLOOKUP!$C$3:$M$104,2,0),"")

 

[MrKowz]

Welcome to the forums!

The easiest way to handle #N/A! errors with a VLOOKUP is to use an error handler:

Excel 2003 or older:
=IF(ISERROR(VLOOKUP(E473,VLOOKUP!$C$3:$M$104,2,0)),"",VLOOKUP(E473,VLOOKUP!$C$3:$M$104,2,0))

Excel 2007 or newer:

=IFERROR(VLOOKUP(E473,VLOOKUP!$C$3:$M$104,2,0),"")

Also, I would reccomend changing the name of the sheet "VLOOKUP". Using variable names or sheet names that are identical to a reserved variable or function can cause some errors that are hard to trace.

 

[JackDanIce]

Welcome to the board. I think this is what you're after, try:

=IF(ISERROR(MATCH(E473,VLOOKUP!$C$3:$C$104,0)),"",VLOOKUP(E473,VLOOKUP!$C$3:$M$104,2,0))