I am looking for a formula to put the "status" of a project from the worksheet Matrix (2) in the right row of the reference table (1). I tried index match but could not solve the problem.
In the ws (1) as shown below there is my table with about 50000 rows and would like automate the task with vba.
In ws 1, in Col A I have the #ID and the date in Col B.
In ws 2 with the Matrix I have the #ID in Col A and the dates in row 1. I would like transfer Col C from Matrix to the Reference Table in Col C if date and ID matches.
First prepare 3 Name Range for Tabelle1 Sheet.
Then in Tabelle2 apply below Array formula confirmed with Ctrl+Shift+Enter and drag through columns and rows:
As your details for Target Column In Tabelle1 is incomplete, it cannot fill the details in Tabelle2.
Please find attached...
If you still wants me to create a VBA, please fill the details for Target