Forum Discussion
Formula
Hi guys, I want the universal formula for the attached book. As seen from the excel book, range F13 in YTD sheet pulls value of C8 of Budget sheet. However, it should pull up the value of C14 of ...
Dharmendra_Bharwad Since both Sales and Cogs share the same row header names, you can't just use INDEX and MATCH on the entire range of the P&L account. Therefore I created named ranges for "budsales", "budcogs" and "budexp". Similarly, I added some named ranges for the months, the categories for Sales and Cogs and Expenses.
Then, I changed the formulae so that they are "looking" at the correct named ranges. See attached. I hope you'll find it useful.