I want to merge the data by using the tickers on sheet 2.
I have found this formula, but it is not correct because it does not take the year into account =IF.WRONG(VLOOKUP(A85925;Blockholder!$A$2:$F$302;3;0);"")

Thanks for helping