Hi

http://www.contextures.com/xlDataVal01.html
combine with VLOOKUP
http://www.contextures.com/xlFunctions02.html

HTH. Best wishes Harald


"Frandonn28" wrote in message
...
My boss asked me to make an estimation sheet form. In one of the colums, I
was asked to make a drop down list for all our 48 A/C products to
eliminate
error. For every product, I have the corresponding value for horse power,
Cap. BTU and Pwr.KW. My boss wants that these cells/fields be
automatically
be populated once the engineer chooses the A/C product from the list. I
dont
know the function to use and how to do it. I desperately need your help.
Thanks!
--
thanks =)