Track Shipments in Excel with XLOOKUP

Keep tabs on orders and delivery statuses effortlessly

November 13, 2024

In partnership with

Hi again Explorers,

We're focusing today on tracking shipments in Excel using the XLOOKUP function. This feature allows you to monitor delivery statuses, track order details, and organize shipments all in one place. If you’re already using Excel for this purpose, feel free to skip today’s edition.

Let’s get started and see how Excel can help you efficiently manage shipments and deliveries!

The process is as follows,

1. Open Excel and Select the cells

Unlock Windsurf Editor, by Codeium.

Introducing the Windsurf Editor, the first agentic IDE. All the features you know and love from Codeium’s extensions plus new capabilities such as Cascade that act as collaborative AI agents, combining the best of copilot and agent systems. This flow state of working with AI creates a step-change in AI capability that results in truly magical moments.

2. Go to “Insert” and click on “Checkbox” to add checkboxes for tracking status.

3. In the cell where you want the status to appear, use XLOOKUP function. Type =XLOOKUP(TRUE, and select the checkboxes.

=XLOOKUP(TRUE,C5:E5,

Instant file upload with API

Instantly add file uploads to your app with Pinata’s API

Pinata’s File API lets developers integrate file uploads and retrieval in just minutes. No complex setup, no configuration headaches—just fast and scalable file management.

4. Select the above Status cell then press F4 and complete the whole formula. The formula:

=XLOOKUP(TRUE,C5:E5,$C$2:$E$2,"",,-1)

Tired of your inbox being overwhelmed by newsletters? With Meco, your favorite reads are neatly organized in a clean, distraction-free space, making it easy to stay on top of the content you love.

We are Done. The shipment tracking system is ready.

That’s how you can set up a simple and effective shipment tracking system in Excel! Whether you’re keeping tabs on orders, monitoring delivery schedules, or organizing logistics, Excel makes it easy to stay on top of your shipments with just a few steps.

We Value Your Feedback

Was this featured story helpful? Rate it, and let us know how we can improve.

How would you evaluate our today's newsletter?

We read your emails, comments, and poll replies regularly. Your feedbacks help us to improve and deliver the best possible newsletter.

Login or Subscribe to participate in polls.

Stay tuned for more Excel tips and tricks in our future issues. If you have any questions or need further assistance, feel free to reply to this email. Happy tracking!!!