<div>
<div class="content wysiwyg-content">
Dear experts,<br />
<br />
Could someone help me understand the below formulae:<br />
<br />
I have understood the sections of '=INDEX(D2:BU2' and 'MATCH(1,D8:BU8,0))'.<br />
<br />
=INDEX(D2:BU2,1,MATCH(1,D8<wbr />:BU8,0))<br />
<br />
what i am strugling is the reason for inclusion of '1' before ',match'.<br />
<br />
Kindly help.
</div>
</div>


Dear experts,

Could someone help me understand the below formulae:

I have understood the sections of '=INDEX(D2:BU2' and 'MATCH(1,D8:BU8,0))'.

=INDEX(D2:BU2,1,MATCH(1,D8:BU8,0))

what i am strugling is the reason for inclusion of '1' before ',match'.

Kindly help.

understanding index formulae

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.