Explanation
To convert an expense in one time unit (i.e.
daily, weekly, monthly, etc.)
to other time units, you could use a two-way INDEX and MATCH formula.
Like so many challenges in Excel, much depends on how you approach the problem.
You might first be tempted to consider a chain ofnested IFformulas.
This can be done, but you’ll end up with a long and complicated formula.
when you’ve got the value, you could simply multiply by the original amount.
The “from” units are listed vertically, and the “to” units are listed horizontally.
For the purposes of this example, we want to match the row first, then the column.
Entering a value as =1/7 is an easy way to avoid entering long decimal values.
INDEX and MATCH provides a nice solution.
Note $D5 is amixed referencewith thecolumnlocked, so the formula can be copied across.
you could use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
