Results 1 to 6 of 6

How to use Match formula

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    15

    How to use Match formula

    1st example
    I try to record the grade based on score using Choose and Match formula. Yet it didn't work as I expected.
    For score>90, the grade is A.

    2nd example
    5 people made a guess. The correct answer is 3. The winner should be B. I used Index & Match formula. It didn't work, either.

    Could anyone help with it?


    excel match.xlsx
    Last edited by Stella2012; 08-15-2012 at 11:10 AM.

Thread Information

Users Browsing this Thread

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

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