+ Reply to Thread
Results 1 to 4 of 4

lookup average and fill in table

  1. #1
    Forum Contributor
    Join Date
    09-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    100

    lookup average and fill in table

    Hi all, i want to average the price in (column B) which has the same win value (column A) and place the aveage in my table in (column E), the first example is in A1 and goes all the way down to A80, but i want to do it for all prices and place in table.

    The first answer is in E:51, but obviously the formula needs to be improved...

    I have attached my spreadsheet.

    Cheers Burdo.
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,332

    Re: lookup average and fill in table

    =IFERROR(AVERAGEIF($A$1:$A$17131,$D2,$B$1:$B$17131),"")
    Try this formula and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Contributor
    Join Date
    09-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: lookup average and fill in table

    Cheers Siva, it worked perfectly!

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,332

    Re: lookup average and fill in table

    Thanks for your feedback

+ 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. Help with VBA code to find bottom row in pivot table and fill table cell borders
    By Eric111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2014, 07:15 PM
  2. [SOLVED] fill reference table based on data available in master Table
    By jsimha in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-31-2013, 12:19 PM
  3. [SOLVED] Working out a grade average using a lookup table
    By kitkatkin in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-29-2012, 07:48 PM
  4. Fill-down for the AVERAGE function, problem
    By Voctron in forum Excel General
    Replies: 2
    Last Post: 04-25-2009, 11:27 AM
  5. [SOLVED] auto fill data into a cell from a lookup table
    By Tetradpoint in forum Excel General
    Replies: 1
    Last Post: 04-19-2005, 12:06 PM

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