+ Reply to Thread
Results 1 to 8 of 8

Match Formula Help!!

  1. 05-11-2017, 04:09 PM #1
    PhenBattle
    PhenBattle is offline
    Registered User
    Join Date
    05-04-2017
    Location
    New York
    MS-Off Ver
    2013
    Posts
    6

    Match Formula Help!!

    So, I'm in dire need of help perfecting this "Match" formula.

    I'm trying to take the information from the Roosevelt file, and transfer it to the Scorecard; in order to condense the information to pass on to my bosses.
    I've tried using "=Match" then clicking the cell that I wanted. But the error keeps coming up.
    Is there a way that I can get the information from E19 on Roosevelt to F17 on the Scorecard. Then have it continuous for future entries/autocalculating?

    Please tell me someone can help.

    Thank you in advanced!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-11-2017, 04:18 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,297

    Re: Match Formula Help!!

    Mayb:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 05-11-2017, 04:24 PM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,959

    Re: Match Formula Help!!

    E19 on Rooseveldt = 38%. F19 on scorecard is a price: 1.13. Have you got the cell refs correct? Otherwise this makes little sense...
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  4. 05-11-2017, 04:32 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,297

    Re: Match Formula Help!!

    Glenn: F17, not F19
    Reply With QuoteRegister To Reply
  5. 05-11-2017, 04:41 PM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,959

    Re: Match Formula Help!!

    Oh Pooh. I'm tired. Signing out now 'cos I can't read...
    Reply With QuoteRegister To Reply
  6. 05-11-2017, 05:14 PM #6
    Xandler
    Xandler is offline
    Registered User
    Join Date
    01-19-2017
    Location
    Michigan
    MS-Off Ver
    2013
    Posts
    92

    Re: Match Formula Help!!

    Got it to work with an index/match formula, I'm sure it can be simplified but here it is:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 05-11-2017, 05:43 PM #7
    PhenBattle
    PhenBattle is offline
    Registered User
    Join Date
    05-04-2017
    Location
    New York
    MS-Off Ver
    2013
    Posts
    6

    Re: Match Formula Help!!

    Thank you!!!! Problem solved!! :D
    Reply With QuoteRegister To Reply
  8. 05-11-2017, 05:49 PM #8
    Xandler
    Xandler is offline
    Registered User
    Join Date
    01-19-2017
    Location
    Michigan
    MS-Off Ver
    2013
    Posts
    92

    Re: Match Formula Help!!

    No problem, if this solves your problem please mark the thread as solved through...I believe it is the thread tools dropdown, and if anyone has helped you please click the Add Reputation star by the user name.

    Thank you
    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. Creating INDEX MATCH MATCH formula based off text in cells
    By bbkdude in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-26-2017, 10:37 AM
  2. Match/Index maybe? Formula to pull a cell in column A based on a match for two columns
    By Lsxtrkiller in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2017, 07:47 PM
  3. ISSUE + MATCH + MATCH formula returning wrong value for some cells, but correct for others
    By kuunamatata in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-12-2016, 03:30 PM
  4. Formula? To match account names in seperate sheets - Containing nearest match
    By RohanF in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-04-2015, 01:59 AM
  5. Need to add iftext in relative cell refrence to a offset(match+match) formula
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2014, 02:13 PM
  6. Index Match Match Formula DOESN'T WORK WITH TABLES/TABLE NAMES ??
    By Underling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 09:01 PM
  7. Index/Match/Match. Formula looking veritcal and horizontal headings to find a match
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-29-2012, 08:51 PM

Tags for this Thread

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