My question is: I need a formula to make excel matches each names in colume B bellow with names in Colume A , then if the two names are matched then copy the mark for each students in colume A infront of each matched student name cell in Colume B. For example : John's mark is 5 , I need from excel to find where is John in Colume B and input John Mark in E6 cell. Colume A Colume B names marks name Marks John 5 David E4 Steve 7 George E5 David 6 John E6 Thomas 1 Steve E7 George 9 Thomas E8
Solved by S. H. in 12 mins