VBA and Table Lookups - HELP !

[Luciferlicks]

I'm building an Excel app for my new business (LED Lighting) which will enable me to collect site survey data (DataCollector).

I then click on a button(Send to Quote) which will populate a "Quotation" tab with a list of products(Pricelist tab) 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

[arthurbr]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.