Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.2.x will end 22 April 2024 (12 months).
  • Bug fixes for security issues in 4.2.x will end 7 October 2024 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.1.x is supported too.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/LookupRef/ -> HLookup.php (source)

[Source view]

Differences Between: [Versions 400 and 402] [Versions 402 and 403]

(no description)

File Size: 121 lines (4 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

HLookup:: (3 methods):
  lookup()
  hLookupSearch()
  convertLiteralArray()


Class: HLookup  - X-Ref

lookup($lookupValue, $lookupArray, $indexNumber, $notExactMatch = true)   X-Ref
HLOOKUP
The HLOOKUP function searches for value in the top-most row of lookup_array and returns the value
in the same column based on the index_number.

param: mixed $lookupValue The value that you want to match in lookup_array
param: mixed $lookupArray The range of cells being searched
param: mixed $indexNumber The row number in table_array from which the matching value must be returned.
param: mixed $notExactMatch determines if you are looking for an exact match based on lookup_value
return: mixed The value of the found cell

hLookupSearch($lookupValue, array $lookupArray, $column, bool $notExactMatch)   X-Ref

param: mixed $lookupValue The value that you want to match in lookup_array
param: int|string $column

convertLiteralArray(array $lookupArray)   X-Ref
No description