iferror with vlookup

[cape]

=IFERROR(VLOOKUP(A8,November!B6:C97, 2, 0), "") That is what I am using to look up one value based on what is entered into A8. What I am trying to accomplish is pulling from three separate sheets November December and January. Then have three to show as an average. Thanks in advance.

[alansidman]

Try this:

= average(iferror(vlookup(A8,November!B6:C97,2,0),""),iferror(vlookup(A8,December!B6:C97,2,0),""),iferror(vlookup(A8,January!B6:C97,2,0),""))

[cape]

Thank you. Perfect. If I may ask another question.

I have 6 teams. With 20 team members that have 7 metrics. I would like to be able to input a team name and return all the metrics for that team.

teama member1 metric1 metric2 metric3 metric4 metric5 metric6 metric7

member2 metric1 metric2 metric3 metric4 metric5 metric6 metric7

member3 metric1 metric2 metric3 metric4 metric5 metric6 metric7

so on and so forth

[Glenn Kennedy]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[cape]

Thanks in advance. I have a team summary tab. When placing the team name I would like to pull the data for all the team members into separate rows. Then enter a different team name and pull in the team
data.test.xlsx