Apr 04 2020 08:20 AM
I have an excel sheet containing 4 columns namely school code, label, school code and English name (in order). Here, columns A and B are from same source and columns C and D are from another source. I need to compare column A and column C and print values of column B in column E if it matches.
Eg: 1912 Aschool 1913 ArunSchool
1913 Bschool 1914 AbinSchool
It should print Bschool in column E in row 1.
Apr 04 2020 08:29 AM
Sorry, didn't catch why it shall be Bschool. Base on your explanations it's returned if A2=C2, that's not the case here. I assume that first column here is column A, which is not obvious.
Perhaps you could submit short sample file with few records and desired result.
Apr 04 2020 08:42 AM
Apr 04 2020 08:56 AM
SolutionThank you.
In G2 formula is
=IFNA(INDEX(B:B,MATCH(E2,A:A,0)),"no one")
and drag it down. Please check in attached file.
Apr 04 2020 08:56 AM
SolutionThank you.
In G2 formula is
=IFNA(INDEX(B:B,MATCH(E2,A:A,0)),"no one")
and drag it down. Please check in attached file.