And i want to return some values on the other table.
In that second table i want to return the last date his name appear from the columns in first table. Example: Last column Akar appeared on 23.06.2022, But Aphrodiette last appeared on 12.06.2022.
I tried HLOOKUP but it always return 23.06.2022.
=HLOOKUP(A5,'Shadow War Battles'!I:I,1,TRUE)
I think I need to enter MATCH and INDEX but I can't understand what exactly I need to enter.
The columns will continue to be filled to the right side and there are blank cells in those columns too.
I am sure it is easy solution but I guess my brain overthink this. Can you help me?