SOLVED

VLOOKUP function help

Copper Contributor

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.

5 Replies

@Adithya_K 

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.

best response confirmed by Adithya_K (Copper Contributor)
Solution

@Adithya_K 

Thank you. 

image.png

In G2 formula is

=IFNA(INDEX(B:B,MATCH(E2,A:A,0)),"no one")

and drag it down. Please check in attached file.

Thank you. That worked

@Adithya_K , you are welcome

1 best response

Accepted Solutions
best response confirmed by Adithya_K (Copper Contributor)
Solution

@Adithya_K 

Thank you. 

image.png

In G2 formula is

=IFNA(INDEX(B:B,MATCH(E2,A:A,0)),"no one")

and drag it down. Please check in attached file.

View solution in original post