VLOOKUP and IF

  • Thread starter Thread starter Richard
  • Start date Start date
R

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.
 
Thanks - that sure looks like what I want to accomplish.
I'll change it as needed and give it a try.
 
Richard said:
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.
Click to expand...

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,
 
Back
Top