Загрузка страницы
Все видеоНовые видеоПопулярные видеоКатегории видео

How to do an XLOOKUP with multiple variables / criteria

XLOOKUP is one of the most useful functions in Excel. But it doesn't work with multiple variables. Here I should you some workaround so that you're able to use multiple variables/criteria in your lookup.

Additional Resources:

How to standardize names in Excel: https://youtu.be/OKxHcnJmTCw

Absolute and relative references
Part One: https://youtu.be/PrJF5cYKZhk
Part Two: https://youtu.be/hotGj69Qd-w

Excel For Accounting course on LinkedIn Learning: https://www.linkedin.com/learning/excel-for-accounting

Rockstar Excel website: https://rockstarexcel.com/

Newsletter for free tips on using Excel to make your life easier: https://rockstarexcel.com/newsletter/

Book a free consultation: https://rockstarexcel.com/book-a-free-discovery-session/

Theme music by Michael Gordon Shapiro: https://mikemusic.com/

Видео How to do an XLOOKUP with multiple variables / criteria канала Rockstar Excel
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
14 апреля 2023 г. 18:30:02
00:07:09
Rockstar Excel
Теги
Правообладателям
Жалоба
Комментарии
Другие видео канала
Convert between Excel and Google Sheets in secondsConvert between Excel and Google Sheets in secondsExcel's new text functions will save you loads of time!Excel's new text functions will save you loads of time!Filters - Excel's Easy buttonFilters - Excel's Easy buttonBONUS VIDEO: People with same first and last name in ExcelBONUS VIDEO: People with same first and last name in ExcelRemove Duplicates From Excel List in SecondsRemove Duplicates From Excel List in SecondsExcel can do research for you! Find facts and create heatmaps in seconds!Excel can do research for you! Find facts and create heatmaps in seconds!Convert Excel to a PDF in 3 secondsConvert Excel to a PDF in 3 secondsMost Useful Excel ShortcutsMost Useful Excel ShortcutsHow to get better at Excel (See my face!)How to get better at Excel (See my face!)If only Da Vinci had access to #excelIf only Da Vinci had access to #excelMixed relative and absolute references make powerful Excel spreadsheets easy!Mixed relative and absolute references make powerful Excel spreadsheets easy!How to Use Relative and Absolute References in ExcelHow to Use Relative and Absolute References in ExcelBlank cells acting weird? Here's how to fix it!Blank cells acting weird? Here's how to fix it!How to copy/import data from print, paper, images, or video into ExcelHow to copy/import data from print, paper, images, or video into ExcelCreate a Dungeons and Dragons Initiative and Hit Point Tracker in Excel in SecondsCreate a Dungeons and Dragons Initiative and Hit Point Tracker in Excel in SecondsHow to clean messy data in ExcelHow to clean messy data in ExcelMaking a Dungeons and Dragons Encounter Tool in Excel - An XLOOKUP TutorialMaking a Dungeons and Dragons Encounter Tool in Excel - An XLOOKUP TutorialMake a Goal Tracker in Excel in 11 MinutesMake a Goal Tracker in Excel in 11 MinutesStandardizing Names Bonus Video - First Initial Last NameStandardizing Names Bonus Video - First Initial Last NameDon't merge cells in Excel! Center across selection insteadDon't merge cells in Excel! Center across selection instead
Статистика портала
Яндекс.Метрика
© 2008-2024 «Информационно-развлекательный портал города Верхняя Салда»
| Карта портала | Реклама | Контакты | Сообщить об ошибке | Соглашения
salda.ws salda.ws@mail.ru
Сейчас на сайте: 512 Статистика портала