I'm trying to figure out how to index a range, compare two columns and then average another column for all results found.
A sample is attached with a manual method to show what the result would be, and then a column where the formula would be placed... any help would be fantastic.
Bookmarks