Here is my problem,
I need to do a vlookup of a department, and depending on the current month, sum a range.
Example: Look up Department "100" from "tbl_Salary_Projection", "Sum(Jan, Feb, March)", "False" March needing to be the current month
I read that you can use an array, but I'm not sure how to make that dynamic to only sum through current month. Example:
=SUM(VLOOKUP(100, tbl_Salary_Projection, {2,3,4,5,6,7,8,9}, FALSE))
There may be an alternate way to accomplish this.
If anyone has any suggestions I am willing to try them.
Very much appreciated,
Bookmarks