I am using a VLOOKUP to pull information from another
workbook. From the info that is pulled determines what is
populated in several other cells. I would like to be able
to either place a 0 or leave the cell blank if there is
nothing of value to pull. I have the VLOOKUP function
copied into 10 cells. However, if nothing is input in the
referenced cell then the VLOOKUP cells display a #N/A. I
hope this isn't too confusing because I surely am. Any
help is appreciated.