Function Problems

How to Use XLOOKUP to Return a Schedule from Another Excel Sheet

Partner Editor Oct 9, 2026 871 views

Question details

Create a schedule lookup that matches a name on one worksheet and automatically returns multiple schedule columns from a different worksheet using a spilling XLOOKUP formula.

How to Use XLOOKUP to Return a Schedule from Another Excel Sheet

Product: Excel / WPS Spreadsheet
Device & OS: not provided
Scenario: Pulling an employee's weekly or monthly schedule from a master sheet to an individual tracking sheet without writing separate formulas for every column.
Observed behavior: Return multiple columns of schedule data dynamically based on a single search criterion, ensuring the data spills correctly across the destination cells.

Before you start

Ensure that the destination cells where the schedule data will appear are completely empty. Any existing text, hidden characters, or data blocking the return array will cause a #SPILL! error.

Solution 1Recommended

Use a Spilling XLOOKUP Formula for Multiple Columns

Utilize XLOOKUP's dynamic array capabilities to return multiple columns of data simultaneously based on a single lookup value.

Unlike traditional VLOOKUP, which only returns a single column of data at a time, XLOOKUP can return an array (multiple columns or rows). By selecting a wider return array, the function automatically "spills" the matched schedule data into adjacent blank cells.

Identify the lookup value

Determine where the employee name will be entered. For example, enter the specific employee name in cell A2 on your target worksheet (e.g., Sheet2).

Enter the XLOOKUP formula

Select the destination cell (e.g., B2 on Sheet2) where you want the schedule data to begin. Type the formula: =XLOOKUP(A2,'Sheet 1'!B:B,'Sheet 1'!C:I,"").

Execute the formula

Press Enter. The formula will search column B on 'Sheet 1' for the name in A2, and return the corresponding row data from columns C through I, spilling the schedule across the adjacent cells automatically.

Use a Spilling XLOOKUP Formula for Multiple Columns

Adjust Sheet Names: Make sure to replace 'Sheet 1' in the formula with the exact name of your master schedule worksheet. If your sheet name contains spaces, you must keep the single quotes around the sheet name in the formula.

Advanced Spreadsheets Made Easy

Manage Schedules Efficiently with WPS Spreadsheet

WPS Spreadsheet fully supports dynamic array formulas, including XLOOKUP, allowing you to seamlessly pull, match, and spill schedule data across multiple worksheets exactly like Microsoft Excel.

1. Open your schedule workbook: Launch WPS Spreadsheet and open the workbook containing your master schedule and target sheets.
2. Select the destination cell: Click on the blank cell next to the employee's name where the schedule data should start.
3. Input the XLOOKUP formula: Type =XLOOKUP(, click the name cell, then switch to the master sheet to highlight the lookup column and the multi-column return range.
4. Apply and spill the data: Add "" for the 'if not found' argument, close the parenthesis, and press Enter to instantly spill the schedule data across the row.

Fully compatible with Microsoft Excel formulas and functions, ensuring your XLOOKUP and dynamic arrays work seamlessly without modification.Easily handle large datasets and complex cross-sheet references without lag.Access a rich library of free built-in templates for employee scheduling and time tracking.Lightweight, fast, and completely free alternative to easily manage everyday spreadsheet tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my XLOOKUP formula returning a #SPILL! error?

A #SPILL! error occurs when the adjacent cells where XLOOKUP needs to output the schedule data are not completely empty. Clear any text, spaces, or formatting in the columns to the right of your formula to allow the data to expand.

Can I use this formula if my schedule data is in a different workbook?

Yes, XLOOKUP works across entirely different workbooks. You just need to have both workbooks open when creating the formula. The software will automatically append the external file path (like '[MasterSchedule.xlsx]Sheet 1'!B:B) to your formula.

What does the empty quote ("") at the end of the XLOOKUP formula do?

The "" acts as the [if_not_found] argument. If the employee name entered does not exist in the master schedule sheet, the formula will gracefully return blank cells instead of displaying a distracting #N/A error.

Excel & Data Problems