Recommendations on a formula or other
Results 1 to 3 of 3

Thread: Recommendations on a formula or other
Thanks Thanks: 0 Likes Likes: 0

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

    Default Recommendations on a formula or other

    I am looking for a recommendation on a formula or other option to best complete the following task.

    I have two data sheets that have different data but have a common identifier between the two, so my ask is to take the common identifier and to essentially merge the data from both sheets onto one sheet. What I have done initially was used VLOOKUP on one sheet and its searching the other data sheet for the common identifier and then bringing along the accompanying data. Here is a copy of my current formula =VLOOKUP($A$35,Case_Form!$A2:$C$44,2,FALSE). My struggle is I would like to be able to bring the whole row of data over rather than my current process where I am changing what cell to bring over in my formula ie 2-3-4-5.... I am sure there is a much better way to accomplish this task. Thanks in advance.

  2. #2
    MrExcel MVP
    Join Date
    May 2009
    Posts
    16,287
    Post Thanks / Like
    Mentioned
    35 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Recommendations on a formula or other

    This formula can be copied across to capture the whole row:
    Code:
    =VLOOKUP($A$35,Case_Form!$A2:$C$44,COLUMNS($A:B),FALSE)
    Joe

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

  3. #3
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,177
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Recommendations on a formula or other

    If the column you are looking for is B, then C, then D, etc, then:

    =VLOOKUP($A$35,Case_Form!$A2:$Z$44,COLUMN(),FALSE)
    Regards Dante Amor

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
  •