Q: I was able to make a drop down list of all our products for the first column (title: unit model) The next three columns are HP (horse power), Cap. BTU/hr and Power kW. My boss wants all these columns to be automatically populated once they choose any on the unit model from the drop down list from the first column (unit model column). I have the values for all the unit models. My problem is I don't know if it is possible to do it and if yes, how to do it. Example Column A Column B Column C Column D Unit Model hp Cap. BTU/hr Pwr/kW AAA-30 BBB-60 CCC-90
A: Use a vlookup. You'll have to make a seperate table that has all the info for the unit models, but when you make it use this function. =vlookup(A1,G1:J10,2,false). A1 will be where the unit model is in the drop down list. G1:K10 (or wherever you put it) will be your new table with Unit, HP, Cap. BTU/hr, and Power kW. 2 is the column of the table it will look at. False will make it look for exact matches. To make it look for the other info, change the 2 to a 3 or 4.