XLOOKUP Partial Match with Numbers | the Multiply by 1 Trick | Getting Good with Excel Takes Time

/in /by

I got a plea one night from someone who needed to match some numbers. He had the right instinct but he stumbled up on a situation where you just have to have seen a lot of Excel over a long period of time to know about this hack.
He needed to match the first 4 numbers in an 8-number string.

He tried the VLOOKUP and LEFT functions. But he didn’t know about the “Multiply by 1 Trick.” You’ll see that trick in this video, but I use XLOOKUP. We’re all about being modern over here. 🤗🤩😁🌶

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2