Lookup Table change with time

---

v-juanli-msft wrote:

Hi Anonymous 

From your screenshot, i'm not clear about which are "budget group", "previous years","employee number".

"One of the employees here is moving to a different budget group (change) and I am not sure how to have the data reflect that without affecting previous years. "

How do you create this lookup table?

(from another table called "source table" here ?

does the "change" occur in "source table"?)

 

Best Regards

Maggie

 

---

I can see how my question was a bit unclear. So my expenses sheet is shown here. The employee number is used ina lookup table to find budget group.

Then we have the original lookup table that I provided. So from 2016-2018 Employee # 13472 was a part of STEER. In 2019 they will be moving to Training H. It is not possible to change their employee number because of how the data is reported. I am trying to find a way to make this changes while ensuring that they are still in the correct budget group for 2016-2018 (STEER).