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!
