🔍 XLOOKUP: Why It’s a Game-Changer in Excel

If you’ve spent hours debugging VLOOKUP or HLOOKUP formulas that mysteriously break when tables change—XLOOKUP is the upgrade you’ve been waiting for. Introduced to simplify data retrieval in Excel, XLOOKUP replaces both VLOOKUP and HLOOKUP by being more powerful, flexible, and error-resistant.

Let’s explore why XLOOKUP > VLOOKUP & HLOOKUP 👇

---

1. 🔄 Works in Any Direction

• ✅ VLOOKUP searches down columns

• ✅ HLOOKUP searches across rows

• ✅ XLOOKUP searches both ways—vertically or horizontally

No more juggling between two different functions!

---

2. 🚫 No Index Numbers Needed

Unlike VLOOKUP or HLOOKUP, which require a column or row index number, XLOOKUP automatically finds the correct value—even if the structure changes.

🛠 VLOOKUP breaks if the table changes.
✅ XLOOKUP adapts.

---

3. ✅ Exact Match by Default

• VLOOKUP and HLOOKUP default to approximate match, which can lead to errors if not set properly.

• XLOOKUP defaults to an exact match, reducing potential mistakes right out of the box.

---

4. ↩ Can Search Bottom-Up or Right-to-Left

VLOOKUP can’t look to the left, and HLOOKUP can’t look up. But XLOOKUP can:

• 🔁 Search bottom to top

• 🔁 Search right to left

That’s serious flexibility.

---

5. ❌ No More Helper Columns

With XLOOKUP, you can return data from anywhere in the table, not just columns to the right.

💡 No need to rearrange data or use helper columns.

---

6. 📤 Returns Multiple Values

While VLOOKUP & HLOOKUP only return a single value, XLOOKUP can return:

• 🔄 Multiple columns

• 🔄 Multiple rows

Perfect for structured and dynamic reports.

---

7. 🧯 Built-in Error Handling

Instead of wrapping formulas in IFERROR(), XLOOKUP simplifies this with its own [if_not_found] argument:

=XLOOKUP(A2, B2:B10, C2:C10, "Not Found")

---

📌 Summary: Why XLOOKUP is the Future

Feature	VLOOKUP / HLOOKUP	XLOOKUP
Works Vertically & Horizontally	❌	✅
Needs Index Number	✅	❌
Exact Match by Default	❌	✅
Search Right-to-Left / Bottom-Up	❌	✅
Returns Multiple Values	❌	✅
Built-in Error Handling	❌ (Needs IFERROR)	✅ (if_not_found)

---

🚫 Windows 11: Microsoft Removes OOBE\BYPASSNRO – Here's the New Local Account Workaround

Microsoft continues its push to force online accounts during the Windows 11 setup process by disabling the well-known OOBE\BYPASSNRO.cmd method. But don’t worry — a new workaround has surfaced, thanks to YouTuber NetworkTecho.

Here’s how you can still create a local account in Windows 11 setup without internet access or Microsoft login.

---

🧭 Step-by-Step: New Local Account Bypass (2025)

🔹 1. Begin Windows 11 Setup

• Boot into the Windows 11 installer.

• Select your Region and Keyboard layout as prompted.

---

🔹 2. Stop at the Secondary Keyboard Layout Screen

• When asked to “Add a second keyboard layout,” DO NOT click Skip.

---

🔹 3. Open Developer Console

• Press Ctrl + Shift + J

• The screen will dim and show a black developer console at the top-left corner (> prompt).

---

🔹 4. Enter Restart Command

Type this case-sensitive command:

WinJS.Application.restart("ms-cxh://LOCALONLY")

🔸 Pro Tips:

• After typing WinJS.A, press Tab to autocomplete to Application.

• After typing res, press Tab to autocomplete to restart.

---

🔹 5. Exit Developer Console

• Press Enter to run the command.

• Then press Esc to close the console.
  (If Esc doesn't work, click on the screen to refocus, then try again.)

---

🔹 6. Local Account Setup

• The setup will refresh.

• Now, you’ll see the Windows 10-style local account screen.

• Enter:

  • Username

  • Password (optional)

  • Security questions

• Click Next.

---

🔹 7. Complete Windows 11 Setup

• Setup will resume.

• After a black screen, you’ll be logged into your new local account.

• Finalize privacy settings, and you’re good to go!

---

✅ Summary

🧱 What Changed	❌ Microsoft removed OOBE\BYPASSNRO.cmd
🔓 New Bypass	WinJS.Application.restart("ms-cxh://LOCALONLY") via dev console
🧑 No MS Account	You can still set up a local account (as of May 2025)

---

🧠 Why It Matters

• Great for privacy-conscious users

• Avoid telemetry and online login requirements

• Useful in offline setups and enterprise deployments

📌 Bookmark this guide — Microsoft may change this again in the future, but for now, it works!

🪟 Windows Update Error: Understand Mysterious Hex Codes Easily

When installing Windows updates, it's common to face cryptic error messages—often displayed as hexadecimal codes like 0x80073701. For system administrators and power users, decoding these can be frustrating.

💡 Example Error Code:

0x80073701

🔍 What Does It Mean?

These hexadecimal codes are part of the Win32 error system and are not immediately human-readable. Thankfully, Windows includes a native tool to help decode them:

🛠️ Use certutil.exe to Translate Error Codes

certutil is a built-in Windows utility primarily used for certificate services, but it also contains a hidden gem: an error code translator.

✅ Command to Run:

certutil -error 0x80073701

🧾 Output:

0x80073701 (WIN32: 14081) - ERROR_SXS_ASSEMBLY_MISSING

🧠 Meaning:

This tells you that a component required by Windows Update is missing—likely a side-by-side assembly (.manifest or .dll file). This often affects cumulative or security updates.

---

🧰 Next Steps to Fix It

1. Run System File Checker (SFC):

   sfc /scannow
   

2. Run DISM to Restore Health:

   DISM /Online /Cleanup-Image /RestoreHealth
   

3. Reboot and try the update again.

4. If error persists, use Windows Update Troubleshooter or download the update manually from Microsoft Update Catalog.

---

💬 Final Tip

When you see any 0x code, remember:

certutil -error 0x[CODE]

...will help demystify it instantly.

📌 Bookmark this tip—it’s a time-saver for any Windows admin or tech enthusiast.

---