Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Vlookup data from a Tables to a single column

  1. #1

    Vlookup data from a Tables to a single column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Guys,

    I'm trying to take the data from the "percentage" tab to the "vlookup" tab into one single column. (Ive already started as an example)
    I could just drag it down, but it would take way too long due to the column change.

    Is there a easier method than this? This is only an example data my original has more than 50 sites and more dates.

    iDummy
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Are we going to look only at the left tables in Percentage tab? I don't see anything in the vlookup tab to match day (number).


  3. #3
    We would look at all of "Victory"'s data first before moving to the next site.
    I set up the vlookup tab exactly how its meant to look like, though I cant figure a way to extract the data without spend hours and hours of time.

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    tRY:

    =IFERROR(INDEX(INDEX(Percentage!D:K,0,MATCH(C2,Percentage!$D$2:$K$2,0)),MATCH(G2,Percentage!A:A,0)),"")


  5. #5
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,463
    Articles
    0
    Excel Version
    2010 on Xubuntu

  6. #6
    Quote Originally Posted by NBVC View Post
    tRY:

    =IFERROR(INDEX(INDEX(Percentage!D:K,0,MATCH(C2,Percentage!$D$2:$K$2,0)),MATCH(G2,Percentage!A:A,0)),"")
    Thank you! That works! Though it only works on the "Average Feb" table, how would I change it to work on both tables?

  7. #7
    Linked Thank you!

  8. #8
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Are they the only 2 tables?


  9. #9
    Quote Originally Posted by NBVC View Post
    Are they the only 2 tables?
    There's a "Average Feb" and an "Average March" for each site

  10. #10
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =IFERROR(IF(B2="Average Feb",INDEX(INDEX(Percentage!D:K,0,MATCH(C2,Percentage!$D$2:$K$2,0)),MATCH(G2,Percentage!A:A,0)),INDEX(INDEX(Percentage!O:V,0,MATCH(C2,Percentage!$O$2:$V$2,0)),MATCH(G2,Percentage!A:A,0))),"")


Page 1 of 2 1 2 LastLast

Posting Permissions

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