office 2000 query

[akiwi65]

Hi all, I have a question for the more educated users of ofice 2000, that hopefully someone can help me with. I am about to open a shop. I would like to know if there is a function on one of the office programs that will allow me to put in a product code (ie 1001 or abcd) and have the product description and price come up automatically. It would save someone entering the information in themselves once it is setup. If there is not this function in office, does anyone know of a possible shareware program out there for this operation
TIA

Greg

 

[xlhelp]

You can do it in Excel using Vlookup, you can do it access quite easiy once it is set up and Dale Watson is your man to explain how to do it Excel (again) using Database functions. Hopefully Dale will see this.