Forum Discussion
How to use vlookup with average function
How to Use VLOOKUP to return the Average Salary of Sales Department.
You could do a crazy workaround.
In E13 type Sales.
In F13:
=AVERAGIFS($C$2:$C$55,$B$2:$B$55,E13)
In F3:
=VLOOKUP(F2,E13:F13,2,FALSE)
That way, you can use VLOOKUP in any formula in Excel! One could create this formula
=N(SUM(PRODUCT(VLOOKUP(F2,E13:F13,2,FALSE))))and claim that all these functions were used to return the average.
By the way, your formula has a point instead of a comma.