I guess my title is not that clear. I did attach a screen with 2 tables to illustrate.
I have 2 files. Top one has some values, and years are in columns. Second one has years as rows.
And I would need to populate the Value Column (oranged colour) by lookingup or whatever in second table (basing on year and Att1).
I did spend quite some time trying to find some info here and in help, but without success
I hope some experienced EM users can help me on this one.