+ Reply to Thread
Results 1 to 3 of 3

using Vlookup with multiple results and averaging the results.

  1. #1
    Forum Contributor
    Join Date
    10-28-2010
    Location
    quebec, canada
    MS-Off Ver
    o365
    Posts
    187

    using Vlookup with multiple results and averaging the results.

    Please Login or Register  to view this content.
    This is a simple Vlookup code that is using an employee number located on S10, and looking into a sheet AHT to bring me back the results on column 7.

    So far so good,

    But now my client is sending me a sheet where S10 may appear multiple time on the AHT sheet.
    i want a formula that will bring me 1 result, and this result needs to be the average of all occurences.


    So, take all the results, average it, and give a results. all the references will be numbers.

    I know i can use index or small, but unsure on how to use that if its really what i need to do.

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: using Vlookup with multiple results and averaging the results.

    Try

    =AVERAGEIF(AHT!A:A;S10;AHT!G:G)

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: using Vlookup with multiple results and averaging the results.

    Sounds like you need something like this:

    =AVERAGEIF(AHT!A1:A100,S10,AHT!G1:G100)

    Adjust the ranges to suit.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using VLookup but results show formula instead of results...
    By excel me in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-28-2013, 09:40 PM
  2. Replies: 3
    Last Post: 10-30-2013, 09:18 AM
  3. VLookup that Results with False or Blank Results
    By mycon73 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-12-2013, 07:16 PM
  4. Replies: 2
    Last Post: 02-03-2012, 12:13 PM
  5. Replies: 3
    Last Post: 03-31-2010, 11:47 AM

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