If G17 is working then there's no reason for H17 not to work... both are in effect doing the same thing only the latter has a result_vector whereas the former does not.

In both cases they simply look for the last numeric value in the column for the requisite depth and either return the value itself (G17) or the associated pressure group (H17).
(it has been assumed per your sample that the numeric values in each depth column are listed in ascending order)

If you can't get this to work please post a sample which illustrates both setup and failing formula(e) at which point we can assist further.