+ Reply to Thread
Results 1 to 4 of 4

Return string of values when two conditions are met.

  1. #1
    Registered User
    Join Date
    01-21-2015
    Location
    Idaho Falls, Idaho
    MS-Off Ver
    Docs.google.com spreadsheets
    Posts
    3

    Return string of values when two conditions are met.

    Hey all,

    I am trying to simplify this process but don't know how. Each week we play a disc golf league, and manually enter in the scores for each of the players. Then we keep individual player stats, and have to enter all those score in manually again. I would like to setup a lookup that will look for the date and players name, and then return their scores to that players sheet.

    I am working on a Mac and don't have Microsoft Office for Mac, so I am utilizing Google Docs.

    The file is here and editable:
    https://docs.google.com/spreadsheets...it?usp=sharing

    Thanks!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,474

    Re: Return string of values when two conditions are met.

    Hi, Im trying to see what your expected answer would look like, but cant find it?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-21-2015
    Location
    Idaho Falls, Idaho
    MS-Off Ver
    Docs.google.com spreadsheets
    Posts
    3

    Re: Return string of values when two conditions are met.

    I'm sorry, I should try to explain this better. So the "Scores" sheet is where I will have to go through and manually enter in everyone's score from their scorecards after league. Then I have only included two "player" sheets. But I would like those sheets to reference the "Scores" sheet and fill in the scores automatically based on the players name, and the correct date. So in the sheet titled "Paden" the scores were entered manually in that sheet AND the Scores sheet. I want to make it so that I only need to enter the scores manually once.

    My dilemma is that not every player will come every week, and that those who are coming a lookup formula will find the players name multiple times. So I need a way for it to return the string of scores for a specific name, and equal to the date.

    Does that make any sense or is that even more confusing?

  4. #4
    Registered User
    Join Date
    01-21-2015
    Location
    Idaho Falls, Idaho
    MS-Off Ver
    Docs.google.com spreadsheets
    Posts
    3

    Re: Return string of values when two conditions are met.

    How about this: The Scores sheet is the resource place where all the scores will be entered Manually. Sheet Paden shows Paden's scores. I would like the Mook sheet to search through the Scores sheet, and return his scores from the appropriate dates. So the Mook sheet should look similar to the Paden sheet except using formulas instead of entering the values manually twice.

    PS Don't worry about the color coding, etc. All I'm interested in is the values.

+ 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] Return text string for a variety of different conditions
    By Terry-J in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-25-2014, 03:40 PM
  2. [SOLVED] Problem With Return Values based on Conditions
    By bakeraj256 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-21-2014, 03:41 PM
  3. Lookup multiple partial match conditions and return values
    By darklans in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-18-2012, 03:26 AM
  4. Replies: 5
    Last Post: 03-02-2011, 08:56 AM
  5. Urgent Help Neeeded - Return Values based on Conditions
    By uberathlete in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-17-2007, 05:31 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1