Forum Discussion
Automate Vlookup to pull in newly dumped data/update lookup range
I have two columns, one for new comments and updates on projects and a second that pulls in the old comments via a VLOOKUP from second archive tab. When I dump the data into the second tab and move ...
I apologize for my poor description and not providing the needed resources to answer my problem.
Looking at screenshot 1, I think looking at the Date of Review and making it conditional or using a dynamic range to look at current date (always 7 days later) and pull the current week into the previous week for the current week's review. Once this current week is completed, I dump into the Archive tab and then VLOOKUP for a rolling comment archive.
Thank you for any help.
Thank you for the sample. In general you need only Current Comments column in Archive, previous week comments could be taken with
=INDEX(Table14[Current Comments],
MATCH(1, INDEX(
(Table14[Account Number]=[@[Account Number]]) *
(Table14[Date of Review]=([@[Date of Review]]-7)),0),
0))