Forum Discussion
How to use vlookup with average function
How to Use VLOOKUP to return the Average Salary of Sales Department.
I think you are all reading too much into this problem. This is some class exercise and I'm willing to bet the teacher just wants them to use VLOOKUP to pull/filter the original list into a new list so they can easily use AVERAGE to find the average salary. The exercise might have been created years ago before AVERAGEIF was introduced or maybe the teacher just hasn't introduced it yet or just needed some reason for them to use VLOOKUP to pull the list.
That said I don't care to do homework for others as they don't learn well that way, but I hope that helps you Rai_Sahab understand what I think the teacher wants you to do. i.e. use VLOOKUP to create rows on the right side for only the Sales Department and then have a cell to calculate the AVERAGE.
That said I don't care to do homework for others as they don't learn well that way, but I hope that helps you Rai_Sahab understand what I think the teacher wants you to do. i.e. use VLOOKUP to create rows on the right side for only the Sales Department and then have a cell to calculate the AVERAGE.