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 <jrkrid...@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.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 >> >> 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.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@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@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. ______________________________________________ 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, minimal, self-contained, reproducible code.
