Results 1 to 6 of 6

Thread: Index Match keeps returning #REF!

  1. #1

    Index Match keeps returning #REF!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    The formula that I am using looks very similar to this =INDEX(DocName.xlsb!Table7[adjustments],MATCH(Table48[[#Headers],[adjustments]],DocName.xlsb!Table7[[#Headers],[adjustments]],0))


    I have a master document that is pulling data from several other documents. I have a table with a column labeled adjustments on both documents and trying to find the value that is listed under that header.

    Master Document:

    AGENT ADJUSTMENT
    DAVID 0
    ASHLEY 1

    Secondary Document:

    ASHLEY
    ADJUSTMENT
    1


    For some reason it keeps giving me #REF! errors if I click within the formula and then click out of it. No changes are made and if I CTRL-Z it doesn't revert back to the original state.

    Any ideas why it may not be working appropriately?

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,828
    Articles
    0
    Excel Version
    O365
    Post the workbooks.

  3. #3
    Here are the workbooks that I am currently working with.

    secondary.xlsb
    Master.xlsb

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,828
    Articles
    0
    Excel Version
    O365
    How will the formula/workbboks differentiate David and say John?

  5. #5
    Each person would have a different workbook with a different name. As shown in the formula it links directly to the file by name and each agent would have a different workbook with the same layout and same cell position that it would be calling from.

  6. #6
    Is there something that I am doing wrong? Or missing within the formula?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •