Basically, I have a table with a bunch of people names vertically and months listed horizontally. Then I have a drop-down list of all months. For the purposes of
=AVERAGEIF I want to use that drop-down list to point to a corresponding column without making 12 different named ranges for every page with the same table I'll need to make in the future.
I want something like
=AVERAGEIF(name_range; Greta; March) when
March is selected in a drop-down, which will return an average between $2557 and $3367.