2.1.961 Part 1 Section 18.17.7.143, HLOOKUP
a. The standard states that argument row-index-num is the row number in argument table-array from which the matching value is to be returned.
-
In Office, argument row-index-num is the row number, truncated to integer, in argument table-array from which the matching value is to be returned.