Dec 03 2021 01:29 PM
Dec 03 2021 01:37 PM
Dec 03 2021 01:37 PM
Why to use VLOOKUP() if you can do that with AVRERAGEIF() ?
Dec 03 2021 01:42 PM
Dec 03 2021 01:43 PM
Dec 03 2021 02:05 PM
Sorry, have no idea how to do that
Dec 03 2021 02:35 PM
VLOOKUP is not a suitable function for calculating an average. The exercise makes no sense.
Dec 03 2021 02:45 PM - edited Dec 03 2021 03:18 PM
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)
Dec 03 2021 02:56 PM
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.
Dec 03 2021 04:20 PM