NERDY HACKS · ADMIN & INBOX

With 400 clients needing their tax codes and only one file that had them, an office worker has Copilot pull the right codes across in less than a minute instead of checking hundreds of clients one by one

Facing a client list with no tax codes and a second file that had every client's code, an office worker who didn't know how to match them asked Copilot, which did it in less than a minute.

TOOL USED

Microsoft Copilot

SPOTTED ON

Eric Jacobson (@GetIrked) · Nov 20, 2026

THEIR CLAIM

Hours of one-by-one lookups, done in less than a minute

TL;DR

What did Eric Jacobson (@GetIrked) use Microsoft Copilot for?

Facing a client list with no tax codes and a second file that had every client's code, an office worker who didn't know how to match them asked Copilot, which did it in less than a minute. Copilot did exactly what they needed in less than a minute.

What they did

They had 400 clients in Washington who each needed their tax code. One file had only some of the clients and no codes, and another file had every client with their tax code. They had no idea how to pull out just the codes they needed and thought they would have to go through hundreds of clients one by one, so they asked Copilot.

How it went

Copilot did exactly what they needed in less than a minute.

"Copilot just saved me HOURS of work."

— Eric Jacobson (@GetIrked)

Worth knowing

  • Spot-check a handful of rows against the original file, especially clients whose names are written differently in the two files. Client records are sensitive, so use a Copilot your workplace has approved for that data.
  • Price check: Microsoft Copilot: free plan; Microsoft 365 Personal: US$9.99/month, or US$8.33/month on a yearly plan (US$99.99/year) (checked Nov 8, 2026).

Try it yourself

Paste this into a chatbot, then add your own details underneath.

I have two spreadsheets. File A lists some of my clients but is missing their [code]. File B lists every client with their [code]. Add the matching [code] from File B to each client in File A, list any clients you couldn't match, and show me the formula you used so I can check it.

Original post

See Eric Jacobson (@GetIrked)'s original post on X → (Nov 20, 2026)

Filed under Admin & Inbox hacks

Sources

  1. Eric Jacobson (@GetIrked) on X, Nov 20, 2026 — the original post
  2. Microsoft Copilot pricing — checked Nov 8, 2026

THE NERD SIGNAL

Rocky digs through the AI noise. You get the good bits.