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
1 Reply
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.
