+ Reply to Thread
Results 1 to 2 of 2

Need Formula Like MATCH that looks up a cell from another sheet

  1. 03-15-2018, 05:38 PM #1
    Steviefiege
    Steviefiege is offline
    Registered User
    Join Date
    10-09-2017
    Location
    England
    MS-Off Ver
    2013
    Posts
    4

    Need Formula Like MATCH that looks up a cell from another sheet

    Hi,

    I'm doing a football spreadsheet & have done most of the formula's (with a little help!) but i'm pretty stuck on the next bit i want to do. In one tab i have it set up to show the highest chances of a particular outcome (e.g. home win) based on the poisson distribution. In another tab (team stats) i've counted up the particular teams home wins for the season & i want that to be underneath but i don't know how to match the two up together. I'll attach the spreadsheet for anyone to have a look at & any help would really be appreciated as its frying my brain.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-16-2018, 10:43 AM #2
    CAntosh
    CAntosh is offline
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Need Formula Like MATCH that looks up a cell from another sheet

    Quote Originally Posted by Steviefiege View Post
    i want that to be underneath
    I'm not really sure what you mean by "underneath"... underneath what? I took my best guess and put the results in M4 and AA4 of the Poisson sheet. I calculated home wins using:

    =INDEX('Team Stats'!C2:C117,MATCH(Poisson!I3,'Team Stats'!A2:A117,0))&" of "&INDEX('Team Stats'!B2:B117,MATCH(Poisson!I3,'Team Stats'!A2:A117,0))

    and away wins with:

    =COUNTIFS(Results!$C$4:$C$20000,Poisson!V3,Results!I4:I20000,"WIN")&" of "&COUNTIF(Results!$C$4:$C$20000,Poisson!V3)

    Take a look at the attachment to see if it'll do:
    Attached Files Attached Files
    If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

    If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
    https://www.excelforum.com/the-water...ke-thread.html
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search a list, Match two Criteria and copy & paste cell info for each match to a sheet
    By jeffingle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2017, 05:02 PM
  2. [SOLVED] Match a cell value in another sheet and copy values below the cell (Index Match)
    By naga in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-17-2017, 03:14 AM
  3. Copy line of data from sheet 1 to sheet 2 if a specific cell on both sheets are a match
    By Teekay360 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2015, 01:18 PM
  4. [SOLVED] Formula required to match a value in sheet 1 to sheet 2 Column A and select a value from B
    By deputydoug in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-10-2015, 08:44 AM
  5. Formula to MATCH Sheet name to a particular cell and if it matches do a SUMIF on the work
    By allygater in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-07-2015, 09:05 PM
  6. look up on sheet 1 match data sheet 2 and fill in cell on first sheet
    By treborharris in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-28-2013, 01:01 PM
  7. Macro to update database, Match Cell value from Sheet 1 in Sheet 2 then copy and paste
    By Zawoooo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-03-2012, 03:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1