INDEX IS NOT RETURNING ALL VALUES.

[Sengster]

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. 

[#2 · Accepted solution]

@Sengster 

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

Please check attached.

[#3]

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

[#4]

@Sengster , you are welcome