As we create more complex worksheets,
keeping track of the many formulas we
might use can become a problem. Using
Range Names in conjunction with our
formulas enables the user to troubleshoot
unexpected results by turning cryptic
formulas into simplified, readable text.
This lesson demonstrates using range
names with VLOOKUP and SUMIF to
achieve the desired results.
Lesson Summary
Lesson 4 Topics
- Range Names
- VLOOKUP
- SUMIF
