備忘録

備忘録

VLOOKUP

=VLOOKUP(SearchCriterion; Array; Index; Sorted)

Sorted is an optional parameter that indicates whether the first column in the array is sorted in ascending order. Enter the Boolean value FALSE or zero if the first column is not sorted in ascending order. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is between the lowest and highest value of the sorted list. In unsorted lists, the search value must be matched  exactly. Otherwise the function will return this message: Error: Value Not Available.

=VLOOKUP(SearchCriterion; Array; Index; 0)
検索値と参照表第一列との完全一致を探す場合、参照表の第一列が非Sortとする値[0]を設定する。
未入力の場合は1になり想定の結果が得られない。