Hey all,
At the office here we run a invoice/quote excel sheet that each page references each other to make a invoice, packing slip, quote, customs papers and such, but now we are looking at implementing a pricing sheet that will allow us to have all of our products in it with product description and price.
What I am wondering is, how can I add all this information in then have it so if I select for say "Logitech Mouse" that the product description automatically comes up in the cell beside it, along with price beside the description?
I was looking into VLookup but that wont work, so I'm not really sure what to do here..
Any help would be great help,
Thanks
Jay
Bookmarks