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 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.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…