Re: [R] HLOOKUP in R

2012-07-16 Thread John Kane
From: jholt...@gmail.com > Sent: Mon, 16 Jul 2012 12:40:10 -0400 > To: jrkrid...@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 nex

Re: [R] HLOOKUP in R

2012-07-16 Thread jim holtman
From: santosh.srini...@gmail.com >> Sent: Sun, 15 Jul 2012 04:56:30 -0700 (PDT) >> To: r-help-arch...@googlegroups.com >> Subject: Re: [R] HLOOKUP in R >> >> Try ?match >> Adapt it to your need >> >>

Re: [R] HLOOKUP in R

2012-07-16 Thread John Kane
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.srini...@gmail.com > Sent: Sun, 15 Jul 2012 04:56:30 -0700 (PDT) > To: r-help-arch...@googlegroups.com > Sub

Re: [R] HLOOKUP in R

2012-07-15 Thread santosh
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@r-project.org mailing list > https://stat.ethz

Re: [R] HLOOKUP in R

2012-07-15 Thread jim holtman
Depending on what options of hlookup you want, 'match' will do exact matching and 'findInterval' will determine range/interval matching. What you need to do is follow the posting guide and provide an example of exactly what you data looks like and what you expect the result to be. On Fri, Jul 13,

Re: [R] HLOOKUP in R

2012-07-15 Thread Liviu Andronic
On Fri, Jul 13, 2012 at 9:25 PM, Silje Nord wrote: > Is there a function similar to excel's hlookup in R ? > Try match(). I think it provides hlookup() functionality. Liviu __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-he

Re: [R] HLOOKUP in R

2012-07-15 Thread Michael Sumner
What does Excel's HLOOKUP do? On Saturday, July 14, 2012, Silje Nord wrote: > Hi, > > Is there a function similar to excel's hlookup in R ? > > Thanks, > Silje > > __ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help >

[R] HLOOKUP in R

2012-07-15 Thread Silje Nord
Hi, Is there a function similar to excel's hlookup in R ? Thanks, Silje __ R-help@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