+ Reply to Thread
Results 1 to 3 of 3

Index, Match , Auto-Filter, Sort

  1. #1
    Registered User
    Join Date
    03-31-2016
    Location
    la,ca
    MS-Off Ver
    2013
    Posts
    2

    Index, Match , Auto-Filter, Sort

    need help, I'm trying to get the value of one column while trying to match two names.
    example:
    sheet 1 Arizonal column A
    sheet 2 Arizonal column CK
    sheet 2 19 column CI

    what I'm trying to do is Match the name's (column A & Column CK) and show the value associated with that name in column CI

    everything see's to work with index, Match (function,formula) but when I re-sort column CK , also when I re-sort any column within sheet 2
    the value is incorrect or says #n/a

    How do I fix this?

    thank you in advance for any help

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2003-2010-2013
    Posts
    2,078

    Re: Index, Match , Auto-Filter, Sort

    Can you supply us with a sample workbook?
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Registered User
    Join Date
    03-31-2016
    Location
    la,ca
    MS-Off Ver
    2013
    Posts
    2

    Post Re: Index, Match , Auto-Filter, Sort

    I'm not at my desk, so I created a quick example of what I was referring to earlier.

    Sheet 1 column C names match sheet 2 column C (sortable column)

    sheet 2 column B , I would like to show up on Sheet 1 column I

    =INDEX(Sheet1!B9:B83,MATCH(Sheet1!C9:C82,Sheet1!C10:C83))

    first cell #n/a , next cell shows 16.9 but its wrong, and when I sort Sheet 2 column C , numbers are still wrong on Sheet 1 column I

    file should be uploaded to review
    Last edited by JG101; 03-31-2016 at 03:50 PM.

+ 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] Auto-Sort or Auto-Filter
    By Brennen81 in forum Excel General
    Replies: 1
    Last Post: 07-19-2015, 08:44 PM
  2. Auto Sort or Auto Filter?
    By vmathews08 in forum Excel General
    Replies: 2
    Last Post: 02-11-2013, 02:21 AM
  3. [SOLVED] Advanced Filter results don't match auto filter
    By WaterWings in forum Excel General
    Replies: 1
    Last Post: 09-13-2012, 05:37 PM
  4. [SOLVED] How to sort without using auto filter
    By bertique in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-06-2012, 09:43 PM
  5. Auto Filter won't sort
    By armoredcars in forum Excel General
    Replies: 5
    Last Post: 10-15-2008, 03:47 AM
  6. Sort, Filter and then auto number sequentially
    By tony0710 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2008, 02:20 PM
  7. Sort; Filter; Match or WHAT???
    By philiphales in forum Excel General
    Replies: 4
    Last Post: 06-25-2008, 09:40 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