+ Reply to Thread
Results 1 to 15 of 15

need help Manipulating a Vlookup

  1. #1
    Registered User
    Join Date
    04-05-2013
    Location
    new york, new york
    MS-Off Ver
    Excel 2010
    Posts
    19

    need help Manipulating a Vlookup

    i have a sheet with identical tables from different States. i am trying to create a lookup that if the state matches(top row) then begin vlookup from that column. Please see below: thanks in advance!!



    Georgia Iowa
    Row Labels POPULATION Row Labels POPULATION
    Fulton 920,581 10% Polk 430,640 14%
    Gwinnett 805,321 8% Linn 211,226 7%
    DeKalb 691,893 7% Scott 165,224 5%
    Cobb 688,078 7% Black Ha 131,090 4%
    Chatham 265,128 3% Johnson 130,882 4%
    Clayton 259,424 3% Woodbury 102,172 3%
    Cherokee 214,346 2% Dubuque 93,653 3%
    Henry 203,922 2% Pottawatt 93,158 3%
    Richmond 200,549 2% Story 89,542 3%
    Muscogee 189,885 2% Dallas 66,135 2%
    Hall 179,684 2% Clinton 49,116 2%
    Forsyth 175,511 2% Warren 46,225 2%
    Last edited by moshro1; 01-08-2014 at 12:50 PM.

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: need help Manipulating a Vlookup

    You can probably use Offset, but I think we need a clearer sample.
    Can you post an actual book?

  3. #3
    Registered User
    Join Date
    12-29-2013
    Location
    Edinburg, Texas
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: need help Manipulating a Vlookup

    When you find a match for the state what variable do you want it to return?

  4. #4
    Registered User
    Join Date
    04-05-2013
    Location
    new york, new york
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: need help Manipulating a Vlookup

    how do i attach it?

  5. #5
    Registered User
    Join Date
    04-05-2013
    Location
    new york, new york
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: need help Manipulating a Vlookup

    the 4th column(the %)

  6. #6
    Registered User
    Join Date
    04-05-2013
    Location
    new york, new york
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: need help Manipulating a Vlookup

    my mistake the 3rd column(%)

  7. #7
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: need help Manipulating a Vlookup

    Quote Originally Posted by moshro1 View Post
    how do i attach it?
    Click "Go Advanced" down by the "Post Quick Reply" button
    Click the "Attachments" button - looks like a paperclip
    Should be self explainatory from there.

  8. #8
    Registered User
    Join Date
    04-05-2013
    Location
    new york, new york
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: need help Manipulating a Vlookup

    here you go. thank you
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    12-29-2013
    Location
    Edinburg, Texas
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: need help Manipulating a Vlookup

    Where do you want to place the data once you find a match

  10. #10
    Registered User
    Join Date
    04-05-2013
    Location
    new york, new york
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: need help Manipulating a Vlookup

    in any column on another sheet

  11. #11
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: need help Manipulating a Vlookup

    what info are you going to input?
    i'll assume its a state and a town/city and you want the % then
    =INDEX(INDEX(Sheet1!$A$4:$BW$170,,MATCH($B$1,Sheet1!$A$1:$BW$1,0)+1),MATCH(C1,INDEX(Sheet1!$A$4:$BW$170,,MATCH($B$1,Sheet1!$A$1:$BW$1,0)-1),0))
    where b1 has a state name and c1 has a name of a town/city in that state
    Last edited by martindwilson; 01-07-2014 at 10:16 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  12. #12
    Registered User
    Join Date
    04-05-2013
    Location
    new york, new york
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: need help Manipulating a Vlookup

    this sounds like it will do the trick! ill check the formula tomorrow and let you know the results. thank you so very much!!

  13. #13
    Registered User
    Join Date
    12-29-2013
    Location
    Edinburg, Texas
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: need help Manipulating a Vlookup

    Are you trying to merge all of the tables into one? Ex. Have a column for state,city,and population all in one?

  14. #14
    Registered User
    Join Date
    12-29-2013
    Location
    Edinburg, Texas
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: need help Manipulating a Vlookup

    Good to see you found an answer

  15. #15
    Registered User
    Join Date
    04-05-2013
    Location
    new york, new york
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: need help Manipulating a Vlookup

    the formula worked perfectly thanks for all the help!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Manipulating strings
    By therealjag in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2010, 08:32 AM
  2. Manipulating data
    By duffsparky in forum Excel General
    Replies: 4
    Last Post: 05-06-2007, 07:12 PM
  3. Manipulating Formula
    By jk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2006, 09:25 AM
  4. Manipulating shapes
    By thePriest in forum Excel General
    Replies: 0
    Last Post: 04-20-2005, 02:06 PM
  5. Manipulating Data in a row
    By Gsurfdude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1