Results 1 to 6 of 6

Match Function

Threaded View

  1. #1
    Registered User
    Join Date
    03-20-2015
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    7

    Match Function

    Hi, My Match Function is not working.. Can anyone see what I am doing wrong.

    I need it to return the next Highest value so I am using the Match type of "-1" but I am getting a "#N/A" Error.. I should be getting a returned value of "10"
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup to Pivot Table, using Match function, returns error if can't find match value
    By AndrewHowarth in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2015, 12:10 AM
  2. [SOLVED] Stuck on Match function with #N/A; attempting to reverse Index/Match
    By Cappytano in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-10-2014, 06:39 PM
  3. INSERT/MATCH Function - can I match and return more than a single result?
    By nickwee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2014, 06:02 AM
  4. Replies: 3
    Last Post: 06-17-2013, 12:37 PM
  5. Replies: 5
    Last Post: 10-26-2012, 02:21 PM

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