SOLVED

INDEX IS NOT RETURNING ALL VALUES.

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
best response confirmed by allyreckerman (Microsoft)
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.

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

@Sengster , you are welcome