Use VLOOKUP and HLOOKUP to use Data Tables in Calculations

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

Using lookup in a calculation or list

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!

Print Friendly, PDF & Email
Share
  • Share
  • Share

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!

Print Friendly, PDF & Email
Share
Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

4 + 1 =