[R] HLOOKUP in R

John Kane jrkrideau at inbox.com
Mon Jul 16 21:33:45 CEST 2012


My quick read of the HVLOOLUP text suggests that an exact match is what is done in Excel or other spreadsheets.  But then, I've never used it.  

I get the impression is often used for things like price lookups.

John Kane
Kingston ON Canada


> -----Original Message-----
> From: jholtman at gmail.com
> Sent: Mon, 16 Jul 2012 12:40:10 -0400
> To: jrkrideau at inbox.com
> Subject: Re: [R] HLOOKUP in R
> 
> 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])    ]
>> hvlook
>> 
>> 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:
>>>> 
>>>> Hi,
>>>> 
>>>> Is there a function similar to excel's hlookup in R ?
>>>> 
>>>> Thanks,
>>>> Silje
>>>> 
>>>> ______________________________________________
>>>> R-help at r-project.org mailing list
>>>> https://stat.ethz.ch/mailman/listinfo/r-help
>>>> PLEASE do read the posting guide
>>>> http://www.R-project.org/posting-guide.html
>>>> and provide commented, minimal, self-contained, reproducible code.
>>>> 
>>> ______________________________________________
>>> R-help at r-project.org mailing list
>>> https://stat.ethz.ch/mailman/listinfo/r-help
>>> PLEASE do read the posting guide
>>> http://www.R-project.org/posting-guide.html
>>> 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
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
> 
> 
> 
> --
> Jim Holtman
> 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.

____________________________________________________________
FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop!



More information about the R-help mailing list