Flexible Lookups example
Products
SumTotal
Cagr
Flexible Lookup
Flexible Lookup
Use a combination of the match() and index() functions in Excel to make your analysis more dynamic.
This is more powerful than vlookup(). I'm glad that I downloaded this example.
Feedback
Product Details
North Park Solutions
Tools for Excel
Free Download