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

F

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!
 
P

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
 
Top