LOOKUP

Home

4D v19

LOOKUP


LOOKUP ( toFind , intervalToSearch , returnInterval )

Parameter	Type	Description
toFind	CellRef, Text, Number, Boolean	Value to find
intervalToSearch	CellRef	Cell range to search
returnInterval	CellRef	Cell range to find corresponding value

Description

The LOOKUP function searches for the value toFind in the intervalToSearch cell range and returns the corresponding value used in the returnInterval range.

toFind must contain the reference of a cell that actually contains the value to find.

intervalToSearch must be sorted in ascending order since LOOKUP uses the first value higher or equal to the value set as toFind.

If toFind cannot be found, it matches the largest value in intervalToSearch that is less than or equal to toFind.

"3", located in the A8 cell, is the value to find. B1:B6 is the interval to search. C1:C6 is the return interval. The B3 cell contains the value to find. The corresponding value in the return interval is in the C3 cell, that is, "697".

LOOKUP

Description

Example