Hi Gurus, I have spent a weekend trying to get the table attached to work using False, True, $ and the usual suspects. Any feedback to point me in the right direction would be id didly good.
It seems to half work. Basically I am trying to do a Vlookup from one sheet to another. The aim is to send toner prices for customer requests. A customer usually tells me the model number of the printer they have. This would be used to pull in data using Vlookup to complete the description and price. The problem is one model number may have several or more toners so I need to include all these in the table. It seems to work at the beginning of the template returning the correct data when I have say model number 5 with 3 different toners but later it just keeps bringup the same data and not the corresponding data it should.
Any ideas whats going wrong? Please help before I jump off a bridge!![]()
Bookmarks