Share via

data tables & index/match function

Anonymous
2022-05-04T18:58:56+00:00
As of yesterday, when I create a data table inside of a file & use that data table for an index/match function, when I hit enter, it asks me for a data source. When I ignore it, the result is either a NA# or a #spill! error. Even worse, when I save the file & reopen it, it is telling me there are external links & there aren't any.<br><br><br><br>I am trying to upload a file but I am not seeing an option to do so.
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-05-05T06:14:53+00:00

    Hello RJS123567,

    Welcome to the Microsoft community and enjoy the time you've spent sharing detailed information. I understand that the problem is when creating a data table in an Excel file and use that data table for the index/match function, getting a NA# or a #spill! error. If my understanding is wrong, please correct me in the answer. I am pleased to offer you assistance on this issue.

    We fully understand the inconvenience caused by the problem and that the current situation can be frustrating.

    Are you encountering errors using datatables and index/match functions only for this particular document? Or are other docs getting the same error?

    It is recommended that you reopen this document in safe mode to see if the problem persists. maybe some add-ons are causing the problem. You can click here to learn how to enter Safe Mode.

    Please share the screenshot of the error message with us so that we can troubleshoot further. Please be careful to hide your personal information when uploading the screenshot.

    From the description you mentioned that you want to upload the document, then you can send us the question document by clicking here.

    We need to go through a series of steps to find the true cause of the problem. If the steps above don't solve your problem, let me know and I will continue to help you with the problem.

    Sincere greetings

    Mavis - MSFT | Microsoft Community Support Specialist

    * Beware of scammers posting fake support numbers here. »

    * Please mark and vote on this answer if it helps, as it will benefit more community members who read here.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-05-05T03:15:08+00:00

    Hi,

    The Community will be glad to assist You.

    - Please share screenshots of Your situation/question (screenshots should include column & row headers)

    + relevant information

    + expected result.

    and/or

    - Please share sample workbook (via OneDrive, Dropbox, WeTransfer, etc.).

    *please hide/delete confidential information

    If You need help with how to upload the file:

    - Please follow the instructions in this 2-minutes long video: Share Files via WeTransfer

    or

    - Please click on this link: Microsoft Office Website

    Thank You!

    Was this answer helpful?

    0 comments