Forum Discussion
Solved
Approximate Match to retrieve values from other table
Hi, I have monthly KPIs achievements in one table updated on monthly basis in 'Table1'. I have separate table for Targets where he changes in targets are updated against each month in 'Table2'. ...
Thanks Idrissshatila , but the above solution I tried earlier and the result is it is only updating the target for the month when the change happened, like illustrated in below table. It is not updating for all month. All other months are remanining blank in new column.
| Month | Achievements | Targets (Retreieved from Table2) |
| Jan-23 | 82% | |
| Feb-23 | 78% | |
| Mar-23 | 88% | 85% |
| Apr-23 | 69% | |
| May-23 | 73% |
- Idrissshatila
Super User
