Skip to content
Prev 286643 / 398502 Next
Original Raw

vlookup type function

Priyan Fernando 
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

Thanks for your help!

Thread (5 messages)

Priyan Fernando vlookup type function Feb 28 Petr Savicky vlookup type function Feb 28 Berend Hasselman vlookup type function Feb 28 William Dunlap vlookup type function Feb 28 Petr Savicky vlookup type function Feb 28