+ Reply to Thread
Results 1 to 5 of 5

nested MATCH function within the INDEX function

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    Washington
    MS-Off Ver
    Excel 2010
    Posts
    3

    nested MATCH function within the INDEX function

    I don't know why but for some reason my brain isn't wanting to work anymore and I'm having an extremely hard time trying to get this assignment done. For the life of me I can't remember how to do nested functions like Match withine08m2june_CaloviDoveAnn.xlsx Index or 3-D formulas. Any help with this would be very much appreciated. The parts I've spent over 5 hours on trying to figure out are listed below..

    -------- Use the nested MATCH function within the INDEX function in cell B40 to identify the date for the highest temperature. the data set may contain several identical highest temperatures, but the nested function will identify the first date containing the match.
    ------- Use a nested MATCH function within the INDEX function in cell C40 to identify the date for the lowest temperature.
    -------- Use a Web browser to go to www.wunderground.com, a weather Web site. Locate and click the HISTORY DATA LINK below the local weather menu, and then do a search for OKC. Copy the URL, and then create a hyperlink to this web page for cell A3 in the OKC worksheet. Add a Screen-tip stating Click to see weather history for Oklahoma City.
    ------- Enter the following 3-D formulas in the appropriate cell in the Summary worksheet:
    -------- Calculate the highest temperature from the three cities for 6/1.
    ------- Calculate the lowest temperature from the three cities for 6/1.
    -------- Enter a nested IF function in cell C6 to determine which city had the highest temperature. Remember to enclose city names in double quotation marks.
    -------- Enter a nested IF function in cell E6 to determine which city had the lowest temperature.
    ------- Enter formulas in the shaded Monthly Records section (below the daily data) to identify the highest and lowest temperatures. Enter nested INDEX and MATCH functions to identify the dates and cities for the respective highest and lowest temperatures.
    Last edited by thechoosenonesdream; 10-25-2012 at 01:32 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Please need help with Excel spread sheet.

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    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
    10-24-2012
    Location
    Washington
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Please need help with Excel spread sheet.

    Thanks! Didn't even think about that when I posted didn't have any sleep for almost 2 days sorry about that.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,726

    Re: Please need help with Excel spread sheet.

    Also, it sounds like homework to me.

    Pete

  5. #5
    Registered User
    Join Date
    10-24-2012
    Location
    Washington
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: nested MATCH function within the INDEX function

    It's actually not homework for school but homework I gave myself. I am trying to teach myself how to use excel for various of reasons so I can hopefully/possibly move up in my job.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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