Results 1 to 5 of 5

nested MATCH function within the INDEX function

Threaded View

thechoosenonesdream nested MATCH function within... 10-24-2012, 10:44 PM
FDibbins Re: Please need help with... 10-25-2012, 12:09 AM
thechoosenonesdream Re: Please need help with... 10-25-2012, 01:33 PM
Pete_UK Re: Please need help with... 10-25-2012, 01:37 PM
thechoosenonesdream Re: nested MATCH function... 10-25-2012, 03:55 PM
  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.

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