Did you use the FALSE statement in the optional portion of the VLOOKUP? This
will insure an exact match instead of defaulting to the 'next closest'
(fairly arbitrary in my opinion).
--
-SA


"Melina" wrote:

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