I have one tab that holds my database information and another tab that references it. I need the data on the first tab to automatically fill in the columns to the left based upon the Resource and the Intr# (see spreadsheet)
I believe =IF(ISNA(VLOOKUP is what I am looking for but don't know how to do it
This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results.
Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.