Month: January 2025

Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. EMT 1868

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1868.xlsx
Learn how to detect what hidden characters are causing N/A! Errors In XLOOKUP And VLOOKUP And Fix It!
Many functions in this video: CODE, CHAR, RIGHT, TRIM, LOOKUP, XLOOKUP, ARRAYTOTEXT, REDUCE, LAMBDA, SUBSTITUTE, REGEXREPLACE, REGEXTEST, UNICODE, and more!
ExcelLambda from YouTube supplies awesome solution!
Topics:
1. (00:00) Introduction.
2. (00:27) Using XLOOKUP and getting an #N/A Error.
3. (01:12) What cause #N/A? Hidden characters that are unknown.
4. (01:40) Check for hidden characters at end of lookup value with RIGHT & CODE function to check.
5. (02:29) Lookup Ascii codes to figure out what it is? LOOKUP function.
6. (03:42) TRIM to Continue reading “Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. EMT 1868” →

Spreadsheet Construction Busn 218 Class @ Highline College, 2025 Winter by Mike “excelisfun” Girvin

Posted on by Annie D

For matriculating students at Highline College, but videos and files free at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo

Spreadsheet Construction Busn 218 Class @ Highline College, 2025 Winter taught by Mike “excelisfun” Girvin

Determine What Causes N/A! Errors In XLOOKUP &VLOOKUP & Fix It! Hidden Characters Problem. EMT 1868

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1868.xlsx
Learn how to detect what hidden characters are causing N/A! Errors In XLOOKUP And VLOOKUP And Fix It! I answer the question: Can you use SUBSTITUTE for many values without nesting? The answer is yes!
Learn how to get the SUBSTITUTE function to replace more than one value! Other ways to phrase this issue:
Multiple Replacements with Excel
Substitute multiple values
SUBSTITUTE function with dynamic array
Excel substitute function array of substitute values
Excel: find and replace multiple values at once
Excel substitute multiple sub text strings with one formula
Excel – Can you use SUBSTITUTE for many values without nesting?
Many functions Continue reading “Determine What Causes N/A! Errors In XLOOKUP &VLOOKUP & Fix It! Hidden Characters Problem. EMT 1868” →

Highline College Statistical Analysis Busn 210 Class 2025 Winter taught by Mike “excelisfun” Girvin

Posted on by Annie D

For matriculating students at Highline College, but videos and files free at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN

Highline College Statistical Analysis Busn 210 Class 2025 Winter taught by Mike “excelisfun” Girvin

Excel I Need A Once In A Lifetime Formula For 2025 – Episode 2665

Posted on by Annie D

Microsoft Excel Tutorial: Looking for a great formula to format 2025 cells.

To download the workbook from today: https://www.mrexcel.com/youtube/_sJiLN5edko/

Start 2025 with a bang by diving into an Excel adventure like no other! In this tutorial, we explore the fascinating concept of “square years”—numbers that are perfect squares of whole numbers—and why 2025 (45 squared) is truly a once-in-a-lifetime event. We’ll walk you through formulas and creative techniques to visualize this unique year in Excel, while tying it back to historical milestones like the California Gold Rush and the completion of the Hoover Dam.

Discover how to create Continue reading “Excel I Need A Once In A Lifetime Formula For 2025 – Episode 2665” →