Office Compatibility Issues

Use VLOOKUP Between Excel Workbooks on iPad: Workarounds and Alternative

Algirdas JasaitisAlgirdas Jasaitis Nov 13, 2026 869 views

Question details

The user needs to create a VLOOKUP formula that pulls data from another Excel workbook while working on an iPad, but Excel for iPad cannot keep two workbooks open at the same time.

How to Use VLOOKUP Between Excel Workbooks on iPad
Product
Microsoft Excel for iPad
Device & OS
iPadOS
Scenario
The user is working on a spreadsheet on an iPad and wants to reference a lookup table stored in a different Excel workbook.
Observed behavior
Excel for iPad closes or replaces the first workbook when a second workbook is opened, so the cross-workbook VLOOKUP workflow available in Excel for Windows or Mac is not available.
Before you start

Before you start, confirm whether the lookup table can be copied or imported into the workbook you are editing on the iPad. If the formula must remain an external link, plan to create or update it in Excel for Windows, Excel for Mac, or another desktop-compatible application.

Solution 1Recommended

Place the lookup data in the same workbook and create the VLOOKUP locally

Use this when you can copy the source table into the current workbook. It is the most reliable iPad workaround because the formula only needs one open file.

Excel for iPad can reference another sheet in the same workbook without needing multiple windows. Moving the lookup table into the same file keeps the formula live and editable on iPad.

1
Open the target workbook in Excel for iPad

Open the Excel app on your iPad, tap the file you want to work with from the Recent or Files list, and wait for the worksheet to appear.

2
Add or copy the lookup data

Select the lookup table in its original location or type or paste it into a new sheet. Tap the plus sign at the bottom left to insert a sheet, then paste the data into the new sheet.

3
Write the VLOOKUP formula locally

Tap the cell where the result should appear, open the formula bar, enter =VLOOKUP(...), and use the sheet name and range that now exist in the same workbook.

Place the lookup data in the same workbook and create the VLOOKUP locally
Formula works on iPad: The formula now updates on iPad because all referenced data is inside the active workbook.
Free Microsoft Office alternative

Use WPS Office to Work with Excel Files Without iPad Multi-Workbook Restrictions

If Excel for iPad limits your VLOOKUP workflow, WPS Office is a free, lightweight Office alternative that keeps .xlsx compatibility and familiar spreadsheet tools while making it easier to manage workbooks on mobile devices.

Create and edit spreadsheets with VLOOKUP in a familiar grid interfaceOpen and save .xlsx files with Microsoft Excel format compatibilityFree to download and easy to use on iPadOS and other devicesSeamless migration from Excel with familiar ribbon-style tools
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for iPad close my first workbook when I open a second?

Excel for iPad does not support multiple workbook instances in the same way as Excel for Windows or Mac. Opening a second workbook replaces the first, so you cannot create an external VLOOKUP reference between two open files on iPad.

Can I create a VLOOKUP between two sheets in the same workbook on iPad?

Yes. Place the lookup data in another sheet in the same workbook, then enter a normal VLOOKUP formula referencing the sheet name and range. This works because both sheets are open in the same file.

Is there a way to refresh a cross-workbook VLOOKUP created on a computer?

You can create and save the formula in Excel for Windows or Mac, then open the workbook on iPad. Saved external references generally remain in the file, but editing or creating new external references on iPad is limited.

Does WPS Office support Excel files and VLOOKUP?

WPS Office opens and edits .xlsx files and supports spreadsheet functions such as VLOOKUP. It is a free, lightweight Office alternative for working with Excel-compatible files across devices.

What should I do if I need side-by-side workbook support on iPad?

Submit feedback through Excel for iPad's Help and Feedback option in the File or account menu, or use a desktop Excel session for that workflow. For a more mobile-friendly alternative, you can also try WPS Office.