What excel function can I use in making a form that auto populate

[Frandonn28]

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!

 

[RagDyer]

You could use the Vlookup() function.

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

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

 

[Harald Staff]

Hi

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

HTH. Best wishes Harald

 

[Peo Sjoblom]

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