Skip to content

2010-01-30 Use VLOOKUP and HLOOKUP to use data tables in calculations

2010 January 30
by admin

I have 100 items to enter into this cost estimation. If I have to lookup the material multiplier each time, I'll go make a mistake. Or I'll go crazy. Lets use VLOOKUP instead!

Popularity: unranked [?]

Print Friendly
Share

Related posts:

  1. Use VLOOKUP and HLOOKUP to use Data Tables in Calculations
  2. Format databases and tables with Magic/Replace
  3. Sparklines: Tiny Graphs to Show Lots of Data
  4. Get Stream Summary Data from SimSci PRO-II into Excel
  5. Get Stream Summary Data from Aspentech Hysys or UniSim Design into Excel

from →

No comments yet

Leave a Reply

Note: You can use basic XHTML in your comments. Your email address will never be published.

Subscribe to this comment feed via RSS

Spam protection by WP Captcha-Free