I'm building an Excel app for my new business (LED Lighting) which will enable me to collect site survey data (DataCollector), and then I click on a button(Send to Quote) which will populate a "Quotation" tab with a list of products to order based on the site survey data.
The Quotation then has a LOOKUP on a "pricelist" tab, to find the relevant unit price of the product, and complete the Draft Quotation to be reviewed prior to sending to a prospect.
I was hoping someone could help me with this "button", in that I've looked at the logic so many times now and cannot find the fix ? The first four(4) line items in my quote has the wrong price ? It appears my LOOKUP is faulty but I cannot see where ?
It is in Excel 2010.
Kind Regards,
Leon
Bookmarks