vlookup type function
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