Here's how the INDIRECT function will help us to do this. Start by typing =AVERAGE(INDIRECT in cell E2, because we're telling Excel that we ... that range as an exact match. We can then use ...

While using Microsoft Excel for data ... Note that the LOOKUP function performs an approximate match. In other words, it ...