INDEX IS NOT RETURNING ALL VALUES.

%3CLINGO-SUB%20id%3D%22lingo-sub-2382856%22%20slang%3D%22en-US%22%3EINDEX%20IS%20NOT%20RETURNING%20ALL%20VALUES.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2382856%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20your%20expert%20advise%20on%20why%20my%20Index%20don't%20return%20all%20the%20values%20despite%20the%20row%20and%20column%20is%20derived%20successfully%20from%20the%20Match(%20).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20inserted%20two%20examples%20in%20Sheet%201.%20It%20seems%20like%20the%20name%20is%20not%20recognized.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2382856%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2382892%22%20slang%3D%22en-US%22%3ERe%3A%20INDEX%20IS%20NOT%20RETURNING%20ALL%20VALUES.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2382892%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1062368%22%20target%3D%22_blank%22%3E%40Sengster%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20exchange%20MATCH()%20positions%20within%20INDEX()%2C%20one%20which%20return%20row%20is%20on%20first%20position%20and%20with%20column%20on%20second%20one.%3C%2FP%3E%0A%3CP%3EPlease%20check%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2387506%22%20slang%3D%22en-US%22%3ERe%3A%20INDEX%20IS%20NOT%20RETURNING%20ALL%20VALUES.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2387506%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much.%20You%20triggered%20something%20i%20missed!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi guys,

 

Appreciate your expert advise on why my Index don't return all the values despite the row and column is derived successfully from the Match( ). 

 

I inserted two examples in Sheet 1. It seems like the name is not recognized. 

3 Replies

@Sengster 

Please exchange MATCH() positions within INDEX(), one which return row is on first position and with column on second one.

Please check attached.

@Sergei Baklan Thank you very much. You triggered something i missed! 

@Sengster , you are welcome