Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
  • Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
  • PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/LookupRef/ -> VLookup.php (source)

[Source view]

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

(no description)

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

Defines 1 class

VLookup:: (3 methods):
  lookup()
  vlookupSort()
  vLookupSearch()


Class: VLookup  - X-Ref

lookup($lookupValue, $lookupArray, $indexNumber, $notExactMatch = true)   X-Ref
VLOOKUP
The VLOOKUP function searches for value in the left-most column of lookup_array and returns the value
in the same row 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 column 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

vlookupSort(array $a, array $b)   X-Ref
No description

vLookupSearch($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