patrick.net » Blog Archive » Short, Sharp, and Wicked::
May 1, 2008 Most Americans and the Wall Street need a bail out, Maybe that’s why I am not making $500K a year, I make quite a bit less than that
http://patrick.net/wp/?p=602HOME |
I desperately need help in Excel functions. I am making a form to be used as estimation sheet in the office. ?
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.
Triannual Unionid Report No. 16, November, 1998::
Need help on life history - will contact Mark Hove, Tom Watters, Chris Barnhart, and registration sheets in this issue of the Triannual Report.
http://ellipse.inhs.uiuc.edu/FMCS/TUR/TUR16.htmlHOME |
Cover Pages: XML Articles and Papers January 2003::
Indices help in building applications that need to navigate through XML Carlson used to have a web-accessible form where you could upload an XMI file
http://xml.coverpages.org/xmlPapers200301.htmlHOME |
Example
Column A Column B Column C Column D
Cleanlink | Contract Services Blog::
This can help significantly reduce the amount of water used for cleaning and something BSCs desperately need to curb illegal subcontracting.
http://www.cleanlink.com/blogs/bsc.aspHOME |
2007 UITS IUB User Survey - Text Comments::
We desperately need more space on the Exchange Servers. quota should be based on the number of sheets used, not the number of sides printed on.
http://www.indiana.edu/~uitssur/2007/iub/iub_text07.htmlHOME |
Unit Model hp Cap. BTU/hr Pwr/kW
AAA-30
BBB-60
CCC-90
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.
Sounds like you may need something more complex; database management software, like MS Access or SQL.
 Red Hat's Rough Recovery From CFO Exit
 Windows Live Finds a New, Pre-installed Home |
HOME