Results 1 to 3 of 3

Finding an average with the lookup function

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2012
    Location
    Akron, OH
    MS-Off Ver
    Excel 2010
    Posts
    2

    Finding an average with the lookup function

    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 10:23 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1