The VLOOKUP
function searches a range for specified value and return specified column data.
For example, assume a data table like below:

Use formula =VLOOKUP(7, A2:E6, 2)
to search this table for index 7:

Result is:

When index value 7 was found, return the second column data from the specified range – “Windows XP”.
There is some notes when using
VLOOKUP
function:
- Data in first column of search table should be sorted (ascending or descending)
- Search target column can only be the first column in search table (cannot specify to search other columns)
- Search target column can contains number or text, but must be sorted
- If specified index value cannot be found, ReoGrid returns the most similar value, see example below
Example: when specified index value cannot be found
When specified index value cannot be found, ReoGrid returns the most similar value in the search table, for example, use formula =VLOOKUP(4, A2:E6, 2)
search the data table above, index value 4 doesn’t exist in first column of search table.

Result is:

‘Windows 2000’ was displayed, the value in row of index value 3, the most similar to specified index value 4 in formula. To exact match the specified index value, see the next section.
Exact match specified value
To force ReoGrid exact match specified index value, set VLOOKUP
function 4th argument to TRUE
, for example:

Result is:

Nothing returned from VLOOKUP
function because specified index value was not found in search table.