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 =)

You could use the Vlookup() function.

Check out Debra Dalgleish's web site on the subject:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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 =)

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 =)

Go here and create the list the same way


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


then assume that you put this dropdown in A1

assume that the list is in S2:V50 with the product name starting in S2 and
the specifications in adjacent cells

In a cell probably on the same row adjacent to the dropdown in A1 (in our
example that would be B1) put

=IF(A1="","",VLOOKUP(A1,S2:V50,2,0)

in C1 put

=IF(A1="","",VLOOKUP(A1,S2:V50,3,0)

in D1 put

=IF(A1="","",VLOOKUP(A1,S2:V50,4,0)



--


Regards,


Peo Sjoblom

"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 =)