Search and display results in userform Issue. Results are incorrect

[olypro]

I have a userform that searches for a product based on a unique number for example( 664907 Printers tray £40.00) this data is located in a sheet called "Stock" Column A has the unique number Column B Has the Item name And column C has the Price.

I have created the userform to search and return the results of column B & C in two Textboxes on the userform.

I also have a clear and add button that works perfectly , however i am struggling, sometimes the results that the userform displays are incorrect. It will jump to a different unique number after i have clicked seraph? Sometimes it will wok and other times it will not, Can anyone help/

Here is the code i am using at present. If anyone can help me this would be great.

Please Login or Register  to view this content.

[dmcgov]

can you upload a sample workbook?

[olypro]

Thanks, The search button that brings up the userfom is on sheet 1, the results when you click add will be copied top sheet 2 and the stock list is where the results are found,
if you try a couple of numbers you will notice that at first it works but then jumps to a different number and product no matter what unique id Number you put in.

Thanks

[rorya]

Code 664907 for example also appears in column H on the Stock sheet, which is what causes the issue.

[olypro]

Thanks, Is it that simple. lol, Wow it all works now. Is there any way to define the colums the serach takes place in and ignores the sold items ? i could always move this info on to another page i guess and still use Vlookup to check stock etc. Thankyou

[rorya]

Instead of using:

Please Login or Register  to view this content.

limit the range like this:

Please Login or Register  to view this content.

for example.