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

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

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