+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Lookup, IF, Then Multiple rows duplicate data

  1. #1
    Registered User
    Join Date
    07-27-2011
    Location
    Cape Town, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    5

    Lookup, IF, Then Multiple rows duplicate data

    Hi All - help please!
    In the attached spreadsheet, if any of the assets rows 7 to 29 have a number in column K, I would like that information in the relevant row to show in rows 71 to 80 in order.

    any recommendations?
    Attached Files Attached Files
    Last edited by azb0105; 08-02-2011 at 05:50 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Lookup, IF, Then Multiple rows duplicate data

    hi azb0105

    find the formula in attatch file.

    note that array formula is used and should be confirmed though Ctrl+Shift+Enter
    Attached Files Attached Files
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.

  3. #3
    Registered User
    Join Date
    07-27-2011
    Location
    Cape Town, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Lookup, IF, Then Multiple rows duplicate data

    Awsome! thanks. It works a treat.

  4. #4
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Lookup, IF, Then Multiple rows duplicate data

    nice

    If your problem is solved, mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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