extract a specific field from array in Google Sheets

Question

I am executing a function in Google Sheets which is resulting into an array output like below

Col1   Col2

A        B

10       20  

What I want is to fetch only 20 and I don't want other rows and columns to be printed. I tried using function array_contrain but that will always print the first column and row. Is there any way to get only a single field from an array.

Answer 1

use INDEX or wrap your formula into INDEX instead of ARRAY_CONSTRAIN

for example:

=INDEX(A:B, 3, 2)