PHPOffice /
PhpSpreadsheet
| @@ 750-757 (lines=8) @@ | ||
| 747 | } |
|
| 748 | } |
|
| 749 | ||
| 750 | if ($rowNumber !== false) { |
|
| 751 | if ((!$not_exact_match) && ($rowValue != $lookup_value)) { |
|
| 752 | // if an exact match is required, we have what we need to return an appropriate response |
|
| 753 | return Functions::NA(); |
|
| 754 | } |
|
| 755 | // otherwise return the appropriate value |
|
| 756 | return $lookup_array[$rowNumber][$returnColumn]; |
|
| 757 | } |
|
| 758 | ||
| 759 | return Functions::NA(); |
|
| 760 | } |
|
| @@ 815-822 (lines=8) @@ | ||
| 812 | $rowValue = $rowData; |
|
| 813 | } |
|
| 814 | ||
| 815 | if ($rowNumber !== false) { |
|
| 816 | if ((!$not_exact_match) && ($rowValue != $lookup_value)) { |
|
| 817 | // if an exact match is required, we have what we need to return an appropriate response |
|
| 818 | return Functions::NA(); |
|
| 819 | } |
|
| 820 | // otherwise return the appropriate value |
|
| 821 | return $lookup_array[$returnColumn][$rowNumber]; |
|
| 822 | } |
|
| 823 | ||
| 824 | return Functions::NA(); |
|
| 825 | } |
|
