+ 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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    51,040

    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!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    51,040

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    51,040

    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... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    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



+ 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