[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • Last Modified:

How to use VLookUp or any other function to retrieve average values of cells?

Hello experts,

You can use the VLOOKUP function to search the first column of a range of cells, and then return a value from any cell on the same row of the range.

Is there anyway I can return all cells that meet my search criteria and average them, rather than only getting the first match.
3 Solutions
Saqib Husain, SyedEngineerCommented:
You can use MATCH to get the row number.

From that you can use the OFFSET function to get a number of columns in that particular row and then you can average it.
MehawitchiAuthor Commented:
Thanks  ssaqibh

I'm not quite sure how to build this into a formula

Can you show me an example please

Why not use


Open in new window

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Saqib Husain, SyedEngineerCommented:
Here is a sample
barry houdiniCommented:
If you are using excel 2007 or later then AVERAGIF function allows you to average data based on a criterion, e.g. to average all cells in column B when column A = "x"


regards, barry
MehawitchiAuthor Commented:
Barry's solution is exactly what I need.
Thank you all
Saqib Husain, SyedEngineerCommented:
I clearly misunderstood your requirements. You should have awarded all points to Barry.
MehawitchiAuthor Commented:
No worries ssaqibh. You made a good attempt after all

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now