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!!!
Bookmarks