Order form - How to get all the info to show by only add code

[mich72]

I would like to crete an order form that once you add the code of the
product all the other information will appear eg Price, description,
colour and so on...
I have seen another programme that did it but cant' find any
information on how to do it..

Thanks in advance for your help

 

[Ron de Bruin]

Hi mich72

Look in the help for the Vlookup function
If you need more help post back

 

[Debra Dalgleish]

You can use a VLookup formula to pull the information from a product
table. There's information and examples for VLookup in Excel's Help, and
more examples here:

http://www.contextures.com/xlFunctions02.html

http://www.contextures.com/xlOrderForm01.html

 

[mich72]

Thank you for your help, will check it out now...