+ Reply to Thread
Results 1 to 6 of 6

VLOOKUP (?) Return values in different row

  1. #1
    Registered User
    Join Date
    10-24-2020
    Location
    Pilsen, CZ
    MS-Off Ver
    MS Office 2010
    Posts
    2

    VLOOKUP (?) Return values in different row

    Hello, wonder if anyone can help with the following.

    I have a sheet with data in cascade; meaning relevant data for cell A1 is in B2, C3, D4 etc.
    Logically vlookup cannot be used normally. Is there any formula, which can return value in different row?

    Attaching excel for example.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: VLOOKUP (?) Return values in different row

    Welcome to the forum.

    What is the logic? Why the value in D4 and not the others?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    10-24-2020
    Location
    Pilsen, CZ
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Re: VLOOKUP (?) Return values in different row

    Thanks

    In general I need to reorganize the database for another import and need to get data in rows and not cascades.
    In the end I need to have in one row data a, b, c, d, e ; in second row data f, g, h, i, j

    Hope it makes sense

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: VLOOKUP (?) Return values in different row

    Are you really using Excel 2010? If so, can you download and install the PowerQuery add-in?

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: VLOOKUP (?) Return values in different row

    Here's the M Code for a PQ solution:

    Please Login or Register  to view this content.
    Excel 365 (Windows) 32 bit
    G
    H
    I
    J
    K
    1
    Column1 Column2 Column3 Column4 Column5
    2
    a b c d e
    3
    f g h i j
    Sheet: List1
    Attached Files Attached Files
    Last edited by AliGW; 10-24-2020 at 05:02 AM.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: VLOOKUP (?) Return values in different row

    or by formula in A12, copied across and down:

    =INDEX($A$1:$E$10,5*(ROWS($1:1)-1)+COLUMNS($A:A),COLUMNS($A:A))

    If that's not waht you want, repost your sheet showing the EXACT answer you want, and where you want to see it.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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. [SOLVED] Why does VLOOKUP return #N/A when all values are there?
    By 1soulknot in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-06-2019, 02:50 PM
  2. [SOLVED] Use vlookup to return first and last-but-one values
    By fred.spark in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-31-2018, 02:35 AM
  3. Vlookup return multiple values horizontally for a list of values
    By lucipurr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-07-2018, 11:00 AM
  4. Replies: 13
    Last Post: 10-13-2014, 02:00 AM
  5. [SOLVED] Vlookup and return values along a Row
    By dabrad89 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-21-2012, 11:32 AM
  6. vlookup multiple values and return values
    By AMFISH in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2012, 11:13 AM
  7. Return 2 values from vlookup
    By adsxvii in forum Excel General
    Replies: 4
    Last Post: 08-28-2008, 09:27 AM

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