XLOOKUP - The VLOOKUP Formula Killer!

Подписаться 1 тыс.

Просмотров 21 тыс.

50% 1

XLOOKUP is one of the most powerful Excel functions, and with a little bit of practice, you can unlock its potential and become an Excel pro!
In this video, I'll show you how to use XLOOKUP to lookup values in Excel, and to perform complex calculations and analysis. By the end of this video, you'll know how to use XLOOKUP to unlock all the advanced functionality in Excel!
#Xlookup #excel #exceltips #vlookup
Chapters
0:00 - Intro
0:19 - How XLOOKUP works
1:34 - How XLOOKUP is better than VLOOKUP
2:21 - XLOOKUPs main arguments
3:56 - How XLOOKUP can replace HLOOKUP
5:34 - Using Wildcards
8:02 - Approx Match
11:09 - 2 Way Lookup
13:25 - Wrap Up
Excel file from video: 1drv.ms/x/s!AkOAGP9X_z5rg14DO...
Like the music in my video?........Get a free trial below
share.epidemicsound.com/oz4cub

Опубликовано:

12 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 19

@PerkinsGreg Год назад

Subscribe here 🛎: ru-vid.com/show-UCSMHCVgRSSFV6Z79PpNSxkg

@schirwa7473 Год назад

Thanks Greg, very useful tool you've shared.

@PerkinsGreg Год назад

Thanks for your kind comments!

@tanjimchowdhury2549 Год назад

You are awesome. Want to learn more from you.

@PerkinsGreg Год назад

Hey, thanks for you're kind comments. Please don't forget to like like and subscribe!

@muhamadk3534 Год назад

very useful. after this i will use this feature more frequent than v or h

@PerkinsGreg Год назад

Thank you for your comments!. XLOOKUP is such a powerful function, I hope it makes you more efficient in Excel!

@shandor2522 Год назад

Thanks for explaining how xlookup replaces older functions. Today, however, it’s time to show how ChatGPT can blow all of this out of the water!

@PerkinsGreg Год назад

Good point! I'll be talking through unlocking the power of ChatGPT on Excel in my next Video!

@ManikandanSriganesan Год назад

Thank you so much .. can you also help on index match pls

@PerkinsGreg Год назад

Thanks for comments. Yes, sure I'll put something together on index & match. Keep an eye out!

@hanumankumar9822 Год назад

If we have multiple same lookup names in that column with different sales values, how to get result of all sales values related to him?

@PerkinsGreg Год назад

Hi, you would need to use the SUMIF function to solve that particular problem

@ogilvy85 Год назад

sir I wlll be grateful if you can organize an XLOOKUP example of "HOW TO LOCATE BUILDING NAMES WITH STREET NAMES" so that if someone asks me for location of any building in my Colony I don't have to remember the name and location

@PerkinsGreg Год назад

Hi, thanks for your comments. I think you'd need to set your data in a table first (with building names and associated street names). You could then use XLOOKUP if you have the building name. You could also use the FILTER function which I'll have a video on in a few weeks so keep an eye out!