Sep 05 2021 11:55 AM
Sep 05 2021 12:10 PM
SolutionYou can use the alternative syntax for INDEX:
=INDEX(array, [row_number], [column_number], area number)
In your example:
=INDEX(namerangename, , , 2)
Sep 05 2021 12:30 PM
Sep 05 2021 12:48 PM
Sep 05 2021 12:10 PM
SolutionYou can use the alternative syntax for INDEX:
=INDEX(array, [row_number], [column_number], area number)
In your example:
=INDEX(namerangename, , , 2)