Creating an invoice from other worksheets
 

I have created a worksheet that allows me to enter a number and then
calculates the price based upon the items chosen. I am trying to create a
customer invoice from this worksheet. It needs to pull the info only if the
value is greater than 0. There are four separate cells for each line of the
worksheet.

Can you help?

Creating an invoice from other worksheets
 

"jodster" wrote:
I have created a worksheet that allows me to enter a number and then
calculates the price based upon the items chosen. I am trying to create a
customer invoice from this worksheet. It needs to pull the info only if the
value is greater than 0. There are four separate cells for each line of the
worksheet.

.. It needs to pull the info only if the value is greater than 0.

One way to cater for the above line is to use something like:
=IF(OR(B2="",B2=0),"",VLOOKUP(B2, ...))
where B2 is the input cell

For VLOOKUP and INDEX/MATCH usage & examples
try Debra Dalgleish's pages at:
http://www.contextures.com/xlFunctions02.html
http://www.contextures.com/xlFunctions03.html

Maybe try also Debra's sample files at:
http://www.contextures.com/excelfiles.html
Look for "Purchase Order"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---