I am trying to make a form that will allow an employee to input an item
number and the description and price will come up in order to make pricing an
arrangement easier. I have used vlookups to accomplish this and to that
point it is working. My problem is that I will put in an item number and the
information for description and price that comes up may be from another item
in the worksheet. At this point it seems totally random, sometimes it is
right, sometimes the same desc. and price will come up for two item numbers.
We have input the data by both individual cells and in some cases the data
has been copied and pasted in blocks. Any ideas?
Thanks for your help