Forum Discussion
Can't Average an Index Match function with "blank" cells
Thanks. Use these. In C33:
=AVERAGE(IFERROR(INDEX('Drop Down'!F2:F6,MATCH(C8:C32,'Drop Down'!E2:E6,0)),""))
In D33:
=AVERAGE(IFERROR(INDEX('Drop Down'!H2:H5,MATCH(D8:D32,'Drop Down'!G2:G5,0)),""))
Thanks. Use these. In C33:
=AVERAGE(IFERROR(INDEX('Drop Down'!F2:F6,MATCH(C8:C32,'Drop Down'!E2:E6,0)),""))
In D33:
=AVERAGE(IFERROR(INDEX('Drop Down'!H2:H5,MATCH(D8:D32,'Drop Down'!G2:G5,0)),""))
HansVogelaar I'm trying to update the formula you helped me with above to produce a word by referencing the number that the current formula calculates. In my attached example, I would like to combine the formula in cell C35 with the formula in cell C33. The end result would be cell C33 producing a word instead of the number like it currently does. Currently, cell C33 assigns a number value to the words in cells C8:C32 and then averages that value in C33. I would like to go a step further and take that number and assign it back to a word. I can't figure out how to combine these two functions into a new function.
See the attached version. I added a lookup range to the Drop-down sheet.
- You are a Rock Star! The math checks out. Thank you for the help!