Share via

iPad Pro using Excel

Anonymous
2025-04-14T20:23:48+00:00

On an iPad Pro using Excel can you use VLOOKUP in one workbook to get data from another workbook

Microsoft 365 and Office | Excel | For home | iOS

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
Accepted answer
  1. Anonymous
    2025-04-15T13:52:04+00:00

    Dear Bob,

    Thank you for your inquiry and for using Excel on your iPad Pro. I understand how important it is to maintain your usual workflow, and I appreciate you reaching out for assistance.

    In Excel for iPad, while the VLOOKUP function works well for looking up data within the same workbook, referencing data from another workbook is not currently supported. This limitation means that if you have data in a separate file, Excel on your iPad won’t be able to pull that data using VLOOKUP in the same way as the desktop version does.

    For scenarios where you need data from two sources, I recommend one of the following workarounds:

    1. Consolidate Data: If possible, combine the necessary data into a single workbook. This approach allows you to successfully use VLOOKUP to reference data within the same file.
    2. Use Excel on Desktop: If combining the workbooks isn’t feasible for your workflow, you might consider performing the operation on a desktop version of Excel, which fully supports external references.

    We continuously review user feedback to enhance Excel on mobile devices, and your input is invaluable as we work on future improvements.

    Thank you once again for reaching out. Please let me know if you have any further questions or need additional assistance.

    Warm regards,

    Scott_LA | Microsoft Community Support.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest