indexing - Excel Match Index greater than zero dynamic range -

i use following code retrieve information 1 worksheet another:

=index('bravo'!$a:$av,match(1,bravo!a:a=$d$4)*('bravo'!c:c=$b7),0)match($c7,'bravo'!$1:$1,0)) 

alpha worksheet display

1. id
2. op_alpha_wtr_temp:1-1(identifies stage water temp at)
3. strl time(start time)

the way works takes 3 pieces of information "alpha" worksheet, cross-references "bravo" spreadsheet , returns value finds in information provided.

i need similar water_temp section, in first screen shoot. cross-reference done on worksheet(charlie). thing i'm trying see if can done using id in d4 cell of alpha worksheet.

if take @ attached charlie worksheet, have 1 result above 0 whole row. i'm trying accomplish match id alpha worksheet charlie worksheet , return value of row above zero.

charlie worksheet display

i need able use dynamic since list in column of charlie worksheet increase or decrease id values depending on length of start time , end time up. there going 6 columns charlie worksheet.

there couple of answers in stackoverflow came close tried piece unsuccessful in attaining looking for.

match link example match link example2

any information can provided appreciated.

thank you.

after playing around couple of days found formula worked: =max(index(('charlie'!a4:a100=d4)*('charlie'!b4:g100>0)*'cha‌​rlie'!b4:g100,)) formula placed on "alpha" "water temp" "d4" cell workbook. referenced "charlie" workbook column a4 thru a:100, matched id d4 alpha workbook , once found in column went through whole row , brought first value found greater zero. hope helps in future.