I am trying to get to check if the elements in a row are matched to some words and hence get the first cell value of the matched row. However, I am not sure if it is the For Each Loop problem or Excel Problem, I cannot get the correct rows. I’ve attached the screenshot below.
I am supposed to get “Ken Soh” and “Max Lim” and put these names in column D, however, it is not working right. Anyone has any ideas how to solve this? Thank you!