I have been struggling to solve this for a couple of days.
I tried some VLOOKUP or INDEX MATCH with multiple criteria but it doesn’t work.
=VLOOKUP(TABLE 2B2&C2,TABLE 1 B:D,3,TRUE)
I have table 1, that is an historic report with a date stamped when the status was changed from one to another for several accounts.
On table 2, I would need to populate the third column with a formula that would return the stage on that date.
e.g.
On the 22/04 when a task was created for Apple the stage was in Pipeline
Account Name | Edit Date | Old Value | New Value |
---|---|---|---|
Apple | 19/04/2021 | Prospect | In Pipeline |
Apple | 01/06/2021 | In Pipeline | Customer |
Table 2
Account Name | Created Date | FORMULA with MATCH RESULT |
---|---|---|
Apple | 22/04/2021 | In Pipeline |
Apple | 01/07/2021 | Customer |
Many thanks for your help on this!