SOLVED

VLOOKUP function help

%3CLINGO-SUB%20id%3D%22lingo-sub-1281364%22%20slang%3D%22en-US%22%3EVLOOKUP%20function%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281364%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20sheet%20containing%204%20columns%20namely%20school%20code%2C%20label%2C%20school%20code%20and%20English%20name%20(in%20order).%20Here%2C%20columns%20A%20and%20B%20are%20from%20same%20source%20and%20columns%20C%20and%20D%20are%20from%20another%20source.%20I%20need%20to%20compare%20column%20A%20and%20column%20C%20and%20print%20values%20of%20column%20B%20in%20column%20E%20if%20it%20matches.%3CBR%20%2F%3EEg%3A%201912%20Aschool%201913%20ArunSchool%3CBR%20%2F%3E1913%20Bschool%201914%20AbinSchool%3CBR%20%2F%3EIt%20should%20print%20Bschool%20in%20column%20E%20in%20row%201.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1281364%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1281380%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20function%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281380%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F609220%22%20target%3D%22_blank%22%3E%40Adithya_K%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20didn't%20catch%20why%20it%20shall%20be%20Bschool.%20Base%20on%20your%20explanations%20it's%20returned%20if%20A2%3DC2%2C%20that's%20not%20the%20case%20here.%20I%20assume%20that%20first%20column%20here%20is%20column%20A%2C%20which%20is%20not%20obvious.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20could%20submit%20short%20sample%20file%20with%20few%20records%20and%20desired%20result.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1281406%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20function%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281406%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20check%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1rj-JQuhcdZ72K4wHh8zxSB5C4aDnpFhrUqPbxlO3X5A%2Fedit%3Fusp%3Dsharing%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1rj-JQuhcdZ72K4wHh8zxSB5C4aDnpFhrUqPbxlO3X5A%2Fedit%3Fusp%3Dsharing%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1281423%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20function%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281423%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F609220%22%20target%3D%22_blank%22%3E%40Adithya_K%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20529px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F182144iD8B37ED21B5351BC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIn%20G2%20formula%20is%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIFNA(INDEX(B%3AB%2CMATCH(E2%2CA%3AA%2C0))%2C%22no%20one%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eand%20drag%20it%20down.%20Please%20check%20in%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1281433%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20function%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281433%22%20slang%3D%22en-US%22%3EThank%20you.%20That%20worked%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1281444%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20function%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281444%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F609220%22%20target%3D%22_blank%22%3E%40Adithya_K%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@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.

Highlighted
Best Response confirmed by Adithya_K (New 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.

Highlighted
Thank you. That worked
Highlighted

@Adithya_K , you are welcome