Forum Discussion
Sengster
May 25, 2021Copper Contributor
INDEX IS NOT RETURNING ALL VALUES.
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.
Please exchange MATCH() positions within INDEX(), one which return row is on first position and with column on second one.
Please check attached.
3 Replies
- SergeiBaklanDiamond Contributor
Please exchange MATCH() positions within INDEX(), one which return row is on first position and with column on second one.
Please check attached.
- SengsterCopper Contributor
SergeiBaklan Thank you very much. You triggered something i missed!
- SergeiBaklanDiamond Contributor
Sengster , you are welcome