Vlookup or vba or code
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 31

Thread: Vlookup or vba or code
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2019
    Posts
    169
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Vlookup or vba or code

    Thanks in advance

    I am using the following vlookup

    Lookup value = C10
    Table array =sheet1!$B$2:$GKX$5
    Col index = 5041
    Range lookup=0

    Now problem is
    I want to change the table array "sheet1!$B$2:$GKX$5" for coloumn from B to GKW

    And also change the coloumn index accordingly, like 5040, 5039

  2. #2
    Board Regular
    Join Date
    Mar 2019
    Posts
    169
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup or vba or code

    I mean in coloumn E
    Lookup value = C10
    Table array =sheet1!$B$2:$GKX$5
    Col index = 5041
    Range lookup=0

    Coloumn F
    Lookup value = C10
    Table array =sheet1!$C$2:$GKX$5
    Col index = 5040
    Range lookup=0

    Coloumn G
    Lookup value = C10
    Table array =sheet1!$D$2:$GKX$5
    Col index = 5039
    Range lookup=0

  3. #3
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,897
    Post Thanks / Like
    Mentioned
    459 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Vlookup or vba or code

    Just drop the column index number by 1 & you should be sorted.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  4. #4
    Board Regular
    Join Date
    Mar 2019
    Posts
    169
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup or vba or code

    i don't want to do it manually

  5. #5
    Board Regular
    Join Date
    Mar 2019
    Posts
    169
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup or vba or code

    hi

    i mean i want don't want to copy paste vlookup code on each column (because we have large number column, From E to GKX)

    If we do it manually we need to change the in "Table array =sheet1!$C$2:$GKX$5", in every column C,D,E,F,G,H it will take more time

    Also pls guide how can we paste it to in every column raws, i mean raw 11 to raw 420 in every column

  6. #6
    Board Regular
    Join Date
    Mar 2015
    Location
    Syria
    Posts
    142
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup or vba or code

    Hi
    for column index
    in column E use 5046-COLUMN()
    then drag up to the column you want

    I hope its is clear

  7. #7
    Board Regular
    Join Date
    Mar 2015
    Location
    Syria
    Posts
    142
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup or vba or code

    Any good !!!!

  8. #8
    Board Regular
    Join Date
    Mar 2019
    Posts
    169
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup or vba or code

    its not working, we need to change two points

    (1) Table array =sheet1!$C$2:$GKX$5
    Col index = 5040

    (2)sheet1!$D$2:$GKX$5
    Col index = 5039

    (3)
    sheet1!$E$2:$GKX$5
    Col index = 5038

    (4)sheet1!$F$2:$GKX$5
    Col index = 5037

    till the GKX and col index 2

  9. #9
    Board Regular
    Join Date
    Mar 2015
    Location
    Syria
    Posts
    142
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup or vba or code

    Can you tell where is the cell for each(1)(2)(3)....

  10. #10
    Board Regular
    Join Date
    Mar 2015
    Location
    Syria
    Posts
    142
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup or vba or code

    Hi;
    Tel you what
    See this and you manipulate to you requirement

    ="sheet1!"&ADDRESS(2;COLUMN()-3)&":"&"$GKX$5"
    Good luck
    Last edited by mohadin; Aug 26th, 2019 at 05:09 AM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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