Forum Discussion
N_iels
Jul 04, 2024Copper Contributor
Making a quotation filled with data from a table on another worksheet
Good morning,
I haven't been using Excel a lot but I've found a template for a quotation that I want to upgrade. On the first sheet I have all the information that needs to come in the quote, and the second sheet I made a table with all items that could come in the quote. Description, quantity, my price, clients price.
No I've got the table at the point I can use it like I want but actually the prices that we sell for should be together with the description, so how can I use one pull down item and make the other colums, like price to follow?
Check out the XLOOKUP function