excel learner
asked on
understanding index formulae
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.
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
what i am strugling is the reason for inclusion of '1' before ',match'.
Kindly help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.