Results 1 to 7 of 7

Formula to find first value that is NON-ZERO with a VLOOKUP

Threaded View

  1. #1
    Registered User
    Join Date
    02-15-2011
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    21

    Formula to find first value that is NON-ZERO with a VLOOKUP

    Hello-

    I am looking for help with a formula in the attached sample data spreadsheet. To describe it, basically I have a data set with a bunch of order numbers in column A and their values going out by date in columns B through whatever depending on the date. In the other sheet I have a list of Order numbers and am trying to write a formula to return the first value for that order that is not zero.

    Here is my current formula, which does not work.

    =VLOOKUP(C5,Data!$A$2:$L$18,MATCH(TRUE,INDEX(Data!6:6>0,0),0),FALSE)
    Unfortunatley, the way the data is maintained, I cannot get the list of orders in the WORKSHEET tab to be in the same order as the DATA tab, so a formula around this problem would be a great help.

    Many thanks in advance for your help!!!
    Attached Files Attached Files
    Last edited by NBVC; 06-09-2011 at 09:56 AM.

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