VLOOKUP/Search issue

Hey folks,

I currently have a sheet contains 2 columns, one of which contains a product code (either 10 or 13 digits long) and the other which contains the name of product.

(so for arguments sake, A1 contains product code, and B2, the product name)

I am trying to create a very quick reference tool which allows the user to enter a prospective product code or product name and have the full details returned, confirming its existence in the list (and possibly some other data too).

I've tried this with VLOOKUP but either have issues with the wrong titles being returned, or an issue in converting the product code column of the array, from custom format to text (as I believe I need to do this for a result to be returned).

Can anyone offer some advice on sorting this?