Hello, I am new to the forums and certainly not an expert at Excel. What I want to do is shown below:
=AVERAGE(LOOKUP(F56,F19:F55,C19:C55):C56)
Note that this function does not actually work. What I want to do is to take a value (F56), go and find where it is previously in the F column, return the result from the corresponding C column, and then average everything between that corresponding C column result and C56. This function does a good job at looking up the correct value, but I am unable to figure out how to do the averaging part. Any help would be greatly appreciated, as I have been stuck on this for hours. Thank you!
Last edited by NBVC; 01-27-2012 at 09:23 PM.
Maybe:
=AVERAGE(INDEX(C19:C55,MATCH(F56,F19:F55,0)):C56)
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
That worked! Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks