Home » Forums » Open Source Learning Center » Question and Answer

Help with formula for invoices

Submitted by pwsausa on 13 November, 2012 - 14:52

I have created a blank invoice and have all of my inventory items in a separate tab but am having trouble with the formula to auto populate the cells. I have followed the exact instructions for vlookup and I am just getting a "0" in my fields. I have attached the template if anyone can help. I am building this for my nonprofit because we have changed database systems and our new system does not print invoices. Thank you so much.

AttachmentSize
INVOICE.xlsx24.06 KB
‹ need help guys create new table after get the line of information that i want form txt ! but it has different line space ›
»
SteveRooms's picture

Re: Help With Formula for Invoices

Submitted by SteveRooms on 13 November, 2012 - 22:48.

Hi pwsausa,

I have looked at your file and it looks to me that you have not formatted the items as text. Once you do this the vlookup will work for you. You also need to insert a new column to the right of Qty in your invoice page so that you can designate whether or not tax should be added. Once you have done this change the formula in cell F32 to column E instead of D so that the sales tax calcs work.

I have made the changes here if you want me to email it over to you. I have also added named ranges, dropdowns in your item fields and formatted the inventory page as a table so that you can automatically add new items.

Regards,
Steve

»
Almir's picture

Help with formula for invoices

Submitted by Almir on 13 November, 2012 - 16:39.

What is your formula like? Where do you place it? Do you enter Inventory number (#) and lookup description or something else? Please include sample of your formula.

»