[R] HLOOKUP in R
jholtman at gmail.com
Mon Jul 16 18:40:10 CEST 2012
There is a "range_lookup" parameter which specifies if you want an
exact match (which is what the solution below assumes), or if you want
the next largest value less than the search value returned; in this
case you would want to use 'findInterval'.
On Mon, Jul 16, 2012 at 12:04 PM, John Kane <jrkrideau at inbox.com> wrote:
> My understanding of HVLOOKUP, based on a through 30 second reading of some on-line documenation is that tht it sets up a grid "table?) of values and if one feeds it the value in the first horizontal vector and a row number it returns the value in that row.
> so if df1[,10] == 15 and you want the value in the second row of the table you would feed in Hvlookput(15, 2) and would return the value in df1[2, 10]
> Of course the values in df[1,] must be unique
> One could put something lile this into a function to get what the op wants, I think
> mda <- data.frame(rbind(hlp <- 1:10, targ <- c(11:20)))
> xx <- 4
> hvlook <- mda[2 , match(1, df1[, xx]) ]
> John Kane
> Kingston ON Canada
>> -----Original Message-----
>> From: santosh.srinivas at gmail.com
>> Sent: Sun, 15 Jul 2012 04:56:30 -0700 (PDT)
>> To: r-help-archive at googlegroups.com
>> Subject: Re: [R] HLOOKUP in R
>> Try ?match
>> Adapt it to your need
>> On Saturday, July 14, 2012 12:55:33 AM UTC+5:30, Silje Nord wrote:
>>> Is there a function similar to excel's hlookup in R ?
>>> R-help at r-project.org mailing list
>>> PLEASE do read the posting guide
>>> and provide commented, minimal, self-contained, reproducible code.
>> R-help at r-project.org mailing list
>> PLEASE do read the posting guide
>> and provide commented, minimal, self-contained, reproducible code.
> FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop!
> R-help at r-project.org mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
More information about the R-help