averageif + vlookup from another sheet

Hi I need someone to crawls data to find 'averageif' in our google sheet,


https://docs.google.com/spreadsheets...#gid=935726050

Please fill in all the yellow colored field in the 2 sub sheets (IS & Details) with formula

Maybe use vlookup at IS and ifaverage in Details

Originally Posted by FDibbins

to do what?

Please provide some sample answers of what you expect, we are not mind readers here lol

Please look at the expected result, I made the text colored in red.
Basicaly, I need a formula that can crawls out onto a set of colomns but skips some data in the colomn.

So if you could take a look, it starts from the details sheet then it crawls onto the IS sheet, then at the the IS sheet it will crawls on the details sheet.

Originally Posted by JeteMc

Although this shows how it might be handled in Excel, perhaps it is transferable and will be helpful.
1. Add a column (A) to the IS sheet populated using**: =AVERAGE(IFERROR((C4:Z4)/(ISNUMBER(C4:Z4)),""))
2. The average industry growth rate on the IS sheet: =SUMPRODUCT((C$1:C$31=C1)*(A$4:A$34))/SUMPRODUCT(--(C$1:C$31=C1))
3. The industry names on the Details sheet**: =IFERROR(INDEX(IS!C$1:C$31, MATCH(0, IF(NOT(ISTEXT(IS!C$1:C$31)), 1, COUNTIF(IS!O$1:O1, IS!C$1:C$31)), 0)),"")
4. The average industry growth rate on the Details sheet: =IF(A2="","",INDEX(IS!G$1:G$31,MATCH(A2,IS!C$1:C$31,0)))
** denotes array formulas which are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Let us know if you have any questions.

Hi,

Thanks I have a looked at the real data but could not succeed, please try directly in our google sheet so we'll know for sure it'll succeed. Because we can't add additional data which you did at sheet "IS" colomn A.