I am trying to return a date based off of a wage threshold. My pivot table has given me something like this:
Column A are ID numbers for an employer. Column B are check dates and Column C are check amounts
Column A has many blanks because the ID is listed once and the other data belongs to that number
What I am trying to do is write a vlookup or index formula that can return the date that the check amounts added to 1,000 or more. I have tried many methods but I cannot get it to work. Any Ideas?
I was thinking an offset vlookup, but I need to be able to copy the formula down for 100's of employers and I am not sure if that will mess up when filling down.
Bookmarks