+ Reply to Thread
Results 1 to 3 of 3

Return Data only if there is a Value

  1. #1
    Registered User
    Join Date
    11-19-2012
    Location
    Manchester
    MS-Off Ver
    Excel 2003
    Posts
    14

    Return Data only if there is a Value

    Hi

    I am trying to write a forumla which will look at a range that might look like this:

    A



    B

    C


    I am need it to return:
    A
    B
    C


    So I want it to lookup to see if there is a value, if so return the cell in the range if not move on until it finds a value. I know I can do it with a macro but I am trying to avoid using macros if possible.

    Or even better, I am using the formula =INDEX($B2:$I6,MATCH(14,$H2:$H6,0),2), I want it to take the data from any match for '14' and then the next row for the next value of 14 and so on.

    Thanks for your help,

    Sam

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: Return Data only if there is a Value

    G'day

    Sounds like you need help with dynamic range formulas with some helper columns. Supply an non sensitivity workbook with the desired results and this forum and we may supply a result for you.
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Registered User
    Join Date
    03-18-2013
    Location
    Stryków, Poland
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    21

    Re: Return Data only if there is a Value

    Use array formula:
    Please Login or Register  to view this content.
    Enter e.g in B1 and drag down.

+ 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