retrive data
1 Topic
Retrive Status From other table using Date range
Hi Everyone, Really need help from expert to retrive status from other table using date parameter and ID. Here my case : Table 1 Id Joining Date Position 1 1 January 2021 Teacher 1 1 January 2022 Admin Table 2 Id Attendance Date 1 2 February 2021 1 3 March 2021 1 2 July 2022 I want to retrive Position from table 1 to table 2, but using joining date(Table 1) and attendance date(Table 2) column as parameter, as you can see Id "1" have 2 position that different in 2021 and 2022. I hope the result will be like this table: Id Attendance Date Position 1 2 February 2021 Teacher 1 3 March 2021 Teacher 1 2 July 2022 Admin As you can see the id on 2 july 2022 being differnet because there were new position from 1 january 2022, and the id took attendance in 2 july 2022. Really need help from expert, already stuck with this for few days. Already tried with lookup value and firstnon blank function but not working.Solved1.5KViews0likes5Comments