For example, in Sheet 1, I want to average the cells in Sheet 2 that are in the column titled "Hello." Sometimes "Hello" is in column A, sometimes B. The workbook has a code that imports data based on the selected date range, and it doesn't always import the data in the same order. Either way, I want to average column "X" in the same cell in Sheet 1. I thought I could use averageif, but this only works if I am consistently trying to average the same column.