[R] vlookup type function

[Berend Hasselman]

On 28-02-2012, at 16:32, Priyan Fernando wrote:

> Hi
> 
> I''m looking for an Excel Vlookup type function in R.
> 
> Example:
> list <- c(1,2,3,4,5,6,7)
> base <- c(2.2,3,5.2)
> 
> What I want is, for each number in base, the highest value in list,
> which is equal to or less than the number in base
> 
> So the results would be:
> 
> base         list
> 2.2  ------> 2
> 3    ------> 3
> 5.2  ------>  5

Don't use "list" as an object name. It is a standard R function.

vlist <- c(1,2,3,4,5,6,7)
base <- c(2.2,3,5.2)

findInterval(base, vlist)

Berend