I am trying to use VLOOKUP in a table with drop down data for Dollar amounts and Time interval to calculkate a Projected Annual dollar amount for the fund-raiser of a non-profit that I have volunteered to help. As a VLLOKUP Rookie, I'm not sure how to arrange the columns in the Table array. I'm also need a formula to change a text entry for the Time interval to a numerical value to be able to calculate the Projected Annual value.
Can anyone help me with this?