Forum Discussion

Sengster's avatar
Sengster
Copper Contributor
May 25, 2021
Solved

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. I...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    May 25, 2021

    Sengster 

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

    Please check attached.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 25, 2021

Sengster 

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

Please check attached.

  • Sengster's avatar
    Sengster
    Copper Contributor
    May 26, 2021

    SergeiBaklan Thank you very much. You triggered something i missed! 

Resources