vlookup: Verticaal zoeken naar waarde in tabel

In msberends/certedata: Tools for Data Analysis at Certe

Description

Dit is een vrije exacte nabouw van de functie VLOOKUP (of VERT.ZOEKEN in Nederlands) van Microsoft Excel.

Usage

vlookup(lookup_value, table_array, col_index_num, range_lookup = FALSE,
  search_column = 1)

Arguments

lookup_value	The value you want to look up, also called the lookup value.
table_array	The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly.
col_index_num	The column number in the range that contains the return value.
range_lookup	Optionally, you can specify TRUE if you want an approximate match or FALSE if you want an exact match of the return value.
search_column	Zie het schuingedrukte deel van de tweede parameter. Dit is R, dus dat bepalen we zelf even.

Source

https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

msberends/certedata documentation built on Nov. 26, 2019, 5:19 a.m.