ExcelBanter - VLOOKUP and IF

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VLOOKUP and IF (https://www.excelbanter.com/excel-programming/288535-vlookup-if.html)

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.

-----Original Message-----
Richard wrote:

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/groups?hl=es&lr=&ie=UTF-
8&threadm=bujj4q%24ik4d4%241%40ID-95421.news.uni-
berlin.de&rnum=1&prev=/groups%3Fq%3Dauthor%
253Abeto_z_O.Borra_Esto%40hotmail.com%26ie%3DISO-8859-1%
26hl%3Des

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,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

.

Richard wrote:

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/groups?hl=es...59-1%26hl%3Des

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,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.