Vlookup that returns he average value for items with multiple values

[AggieGradStudent]

Attached is the relevant workbook.

I need a formula that does the following:
-Enter Job Code
-Finds Salary data for Job Code in another worksheet
-Averages the salaries for the job code
-Returns a single average salary figure for each job code


Thanks!

[Pete_UK]

You can use this formula in B2 of Sheet2:

=IFERROR(AVERAGEIF(Sheet1!A:A,A2,Sheet1!B:B),"")

Hope this helps.

Pete

[AggieGradStudent]

Bump for views

[AggieGradStudent]

You can use this formula in B2 of Sheet2:

=IFERROR(AVERAGEIF(Sheet1!A:A,A2,Sheet1!B:B),"")

Hope this helps.

Pete

It needs to be a lookup

[Jonmo1]

No it doesn't.

Just try it.

[Pete_UK]

It needs to be a lookup

Why?

VLOOKUP is not appropriate in this case as it will return ONLY the first occurrence where you have multiple values.

Pete

[FDibbins]

It needs to be a lookup

why?

Is this a homework assignment?

[AggieGradStudent]

It's been resolved. And no it didn't need to be a lookup apparently haha

Pete's formula worked perfectly!

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.