How to | Create a Dropdown Price List | Google Sheets / Excel

How to make a drop down price list, add to an invoice or quote, using google sheets, same techniques can be used in excel. Ideal for small businesses with small price lists that want to integrate prices into their quotes/ invoices. Part of the How to automate invoices playlist.

Want to learn more ?

No time to learn?

[bloomfieldanalysis]

Thank you for watching!


Want to learn more ?


No time to learn?
Buy ready made premium templates:

[Thissisliss]

Great Video! I am a bit of a novice when it comes to google sheets. I keep getting lost when I get to the vlookup portion. It's not following me over to the Pricelist sheet. Do you have any thoughts on why this is happening? Thanks!

[odiepayne]

Thank you! this was extremly helpfull!

[mustasimarif]

Is it possible to automatically change the invoice number?

[facebythewind]

Thank you for this tutorial it really helped me understand

[ibrahimsholeh]

thanks, by the way, how to create dropdown changing currency list.. for example a dropdown that change a cell from value $400 to 400% and otherwise ??

[tallyerptutorials]

How to transfer to data sheet from this form ?

[autoloza]

Is there any way to clear it without deleting formulas?

[evergarcia]

How about If I have a data validation dropdown on colum B and want to insert values to individual catergories without a price sheet as the prices vary (im making a budget/expense tracker and want to be able to change multipe catergories without copying and pasting rows of the same day but different catergories) sorry if that seems confusing

[camilabelenlagos]

Am I the only idiot that is following this very simple tutorial step by step and still gets an error message?