VLOOKUP and IF

[Richard]

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.

 

[Richard]

Thanks - that sure looks like what I want to accomplish.
I'll change it as needed and give it a try.

 

[Beto]

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.

http://groups.google.cl/[email protected]&ie=ISO-8859-1&hl=es

Take a look at this, discussed just over an hour ago.
Check the link. It should be on one line, so you may need to do multiple
copy paste.

Regards,