Forum Discussion
match two attributes across the table returns the third attribute value
I want to find A average data from sheet, but need to match the value B Value B from sheet 1 is the same of it in sheet 2 Here is the form
Marcolex Not entirely sure I understood what you are asking for but I suspect that you need the AVERAGEIF function. It averages the values from Sheet1, column A for the names listed in Sheet2, column A.