<div>
You can use MATCH to get the row number.<br />
<br />
From that you can use the OFFSET function to get a number of columns in that particular row and then you can average it.
</div>


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.

<div>
Thanks &nbsp;ssaqibh<br />
<br />
I'm not quite sure how to build this into a formula<br />
<br />
Can you show me an example please
</div>


Thanks  ssaqibh

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

Can you show me an example please

lookup-Average.xlsx

<div>
Barry's solution is exactly what I need.<br />
Thank you all
</div>


Barry's solution is exactly what I need.
Thank you all

<div>
I clearly misunderstood your requirements. You should have awarded all points to Barry.
</div>


I clearly misunderstood your requirements. You should have awarded all points to Barry.

<div>
No worries ssaqibh. You made a good attempt after all
</div>


No worries ssaqibh. You made a good attempt after all

<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
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. <br />
<br />
Is there anyway I can return all cells that meet my search criteria and average them, rather than only getting the first match.
</div>
</div>


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.

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.