In our example ISBLANK(Range) creates the following array. MATCH(FALSE,{TRUE;TRUE;TRUE;FALSE;FALSE;FALSE;FALSE},0) then looks for the first exact match to a FALSE value within this array. This returns the value 4 since the first FALSE value is in the 4th position and this is our first non blank cell is in the range.