How to get row number and cell value based on calculated cell value from a range

[Ria]

Hello all:

I have only basic knowledge of excel and learning. I need expert help.
I have excel file data in columns: E, F, G, H
I need to retrieve some numbers based on some criteria: e.g. YELLOW Cells A15 & B15 where I enter search range (depth: col E).
My other formulas need to search in this range based on criteria and return me value. e.g. My range is: A15: 1100 & B15: 1190 then
I enter following array formula in cell B17 {=MIN(IF(INDEX(G:G,A13):INDEX(G:G,B13)>0,INDEX(G:G,A13):INDEX(G:G,B13)))}, it gives me value = 77 (from col: G)
Now I need to find row number of this value in specified range, then return me relevant cell value from col: E into cell: C17 which is row=E784 & value: 1126.5
I am entering following formula in cell C17 but it is giving me wrong answer that does not belong to range I use. please help me to correct this formula. Here is my formula: {=INDIRECT("E"&MATCH(B17,INDEX(G:G,A13):INDEX(G:G,B13),0))}

I am stressed out surfing internet for solution but can get to the point. Now please help. Data file is attached. I am using excel 2007 and will not be able to open files in higher version of excel.

 

[Ria]

Hello all:

I have only basic knowledge of excel and learning. I need expert help.
I have excel file data in columns: E, F, G, H
I need to retrieve some numbers based on some criteria: e.g. YELLOW Cells A15 & B15 where I enter search range (depth: col E).
My other formulas need to search in this range based on criteria and return me value. e.g. My range is: A15: 1100 & B15: 1190 then
I enter following array formula in cell B17 {=MIN(IF(INDEX(G:G,A13):INDEX(G:G,B13)>0,INDEX(G:G,A13):INDEX(G:G,B13)))}, it gives me value = 77 (from col: G)
Now I need to find row number of this value in specified range, then return me relevant cell value from col: E into cell: C17 which is row=E784 & value: 1126.5
I am entering following formula in cell C17 but it is giving me wrong answer that does not belong to range I use. please help me to correct this formula. Here is my formula: {=INDIRECT("E"&MATCH(B17,INDEX(G:G,A13):INDEX(G:G,B13),0))}

I am stressed out surfing internet for solution but can get to the point. Now please help. Data file is attached. I am using excel 2007 and will not be able to open files in higher version of excel.

NEW XL FILE ATTACHED. I am sorry initial xl file attached had extra contents which is confusing. Please use this file instead. All other formulas in sheet were developed through your help.

 

[Ria]

NEW XL FILE ATTACHED. I am sorry initial xl file attached had extra contents which is confusing. Please use this file instead. All other formulas in sheet were developed through your help.

HELLO ALL. Requesting again.Simplifying question: I need to make following formula working or any other formula you suggest that can do the job would be appreciated. Following formula works but I need to add condition on it:
Current formula: INDIRECT("E"&MATCH(B17,INDEX(G:G,A13):INDEX(G:G,B13),0)) ==> works but I need to add condition e.g. when values in a range: INDEX(G:G,A13):INDEX(G:G,B13) > 0 then do rest of work (other words, only consider value greater than 0 in a range). How to add condition that will work. Please help