Can't store/read merged cell in excel

I have this code that I use to match with a certain column in an Excel, to get a datarow. There are some certain codes that each has a different codename, but matches the same account number(Like Codename1, Codename2, and Codename3 has an account number of USD.12636.BUY). I can get all the row values for Codename 1, but for the merged rows for Codename2 and 3, I can only get upto their codenames only. I hope you can help me with this. Thank you.

Hi @Shinjid,
Could you show example screenshots of the data and explain it step-by-step?