You need to include a fourth parameter in your VLOOKUP formula, set to
0 or FALSE. This will ensure that the formula looks for an exact
match. It sounds as if you are searching data which has not been
sorted, and if you omit the fourth parameter it will give you the
effects that you describe.

Hope this helps.

Pete

On Aug 21, 11:08*pm, 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