93K views · 434 reactions | Dynamic Use of #XLOOKUP & Two Way Return Array in XLOOKUP in #Excel 365 (Alternate INDEX+MATCH) =XLOOKUP(B7,item,XLOOKUP(C7,quantity,discount,0,-1),0,-1) =IFNA(INDEX(discount,MATCH(B7,item,0),MATCH(C7,quantity,1)),0) | Excel Basement | Facebook
0:28
FacebookExcel Basement
93K views · 434 reactions | Dynamic Use of #XLOOKUP & Two Way Return Array in XLOOKUP in #Excel 365 (Alternate INDEX+MATCH)
Excel Basement. Excel Basement · Original audio. Dynamic Use of #XLOOKUP & Two Way Return Array in XLOOKUP in #Excel 365 (Alternate INDEX MATCH) =XLOOKUP(B7,item,XLOOKUP(C7,quantity,discount,0,-1),0,-1) =IFNA(INDEX(discount,MATCH(B7,item,0),MATCH(C7,quantity,1)),0)
24.3K views1 week ago
XLOOKUP Tutorial
Excel XLOOKUP Function Tutorial | Learn XLOOKUP Step by Step #focusinguide #Excel #XLOOKUP #ExcelTutorial #ExcelFunctions #LearnExcel #ExcelTips #DataAnalysis #ExcelFormulas #ExcelTricks #OfficeSkills | Focusinguide
0:19
Excel XLOOKUP Function Tutorial | Learn XLOOKUP Step by Step #focusinguide #Excel #XLOOKUP #ExcelTutorial #ExcelFunctions #LearnExcel #ExcelTips #DataAnalysis #ExcelFormulas #ExcelTricks #OfficeSkills | Focusinguide
FacebookFocusinguide
22K views2 months ago
Using Excel's XLOOKUP Function
11:16
Using Excel's XLOOKUP Function
YouTubeTechnology for Teachers and
122.7K viewsMay 17, 2021
Using XLOOKUP Across Multiple Workbooks
7:13
Using XLOOKUP Across Multiple Workbooks
YouTubeK2 Enterprises
55.3K viewsJun 11, 2020
Top videos
17 Reasons Why Your XLOOKUP is Not Working
17 Reasons Why Your XLOOKUP is Not Working
automateexcel.com
Feb 9, 2023
Excel Dynamic Array Functions - Video#10: Xlookup Vs Vlookup - Which one would you choose?
Excel Dynamic Array Functions - Video#10: Xlookup Vs Vlookup - Which one would you choose?
YouTubeAAA Excel’s Power
915 viewsDec 26, 2020
Excel XLOOKUP vs VLOOKUP: A Comprehensive Guide
Excel XLOOKUP vs VLOOKUP: A Comprehensive Guide
TikTokspreadsheetnation
435.2K viewsSep 1, 2021
XLOOKUP Vs VLOOKUP
When to use VLOOKUP instead of XLOOKUP - Excel Campus
When to use VLOOKUP instead of XLOOKUP - Excel Campus
excelcampus.com
Jun 22, 2022
FILTER vs VLOOKUP, INDEX/MATCH, XLOOKUP, SUMIFS - Excel University
FILTER vs VLOOKUP, INDEX/MATCH, XLOOKUP, SUMIFS - Excel University
excel-university.com
Oct 8, 2020
VLOOKUP vs XLOOKUP . . . . . . . . .#Excel #MicrosoftExcel #ExcelTips #Spreadsheet #DataAnalysis #ExcelFormula #ExcelVBA #ExcelShortcuts #ExcelDashboard #DataVisualization #Automation #ExcelFunctions #ExcelTricks #Productivity #ExcelExperts #ExcelTraining #DataManagement #Office365 #ExcelForBusiness #ExcelHacks #ExcelSkills #PowerQuery #PowerBI #ExcelTutorial #ExcelGeek #BusinessIntelligence #Reporting #DataScience #WorkSmarter | Data Driven Insights
6:17
VLOOKUP vs XLOOKUP . . . . . . . . .#Excel #MicrosoftExcel #ExcelTips #Spreadsheet #DataAnalysis #ExcelFormula #ExcelVBA #ExcelShortcuts #ExcelDashboard #DataVisualization #Automation #ExcelFunctions #ExcelTricks #Productivity #ExcelExperts #ExcelTraining #DataManagement #Office365 #ExcelForBusiness #ExcelHacks #ExcelSkills #PowerQuery #PowerBI #ExcelTutorial #ExcelGeek #BusinessIntelligence #Reporting #DataScience #WorkSmarter | Data Driven Insights
FacebookData Driven Insights
21.5K views11 months ago
17 Reasons Why Your XLOOKUP is Not Working
17 Reasons Why Your XLOOKUP is Not Working
Feb 9, 2023
automateexcel.com
Excel Dynamic Array Functions - Video#10: Xlookup Vs Vlookup - Which one would you choose?
Excel Dynamic Array Functions - Video#10: Xlookup Vs Vlookup - …
915 viewsDec 26, 2020
YouTubeAAA Excel’s Power
Excel XLOOKUP vs VLOOKUP: A Comprehensive Guide
Excel XLOOKUP vs VLOOKUP: A Comprehensive Guide
435.2K viewsSep 1, 2021
TikTokspreadsheetnation
Using Excel's XLOOKUP Function
11:16
Using Excel's XLOOKUP Function
122.7K viewsMay 17, 2021
YouTubeTechnology for Teachers and Students
How to Use XLOOKUP in Microsoft Excel
13:39
How to Use XLOOKUP in Microsoft Excel
217.7K viewsJan 4, 2020
YouTubeKevin Stratvert
VLOOKUP & HLOOKUP in Excel Tutorial
6:30
VLOOKUP & HLOOKUP in Excel Tutorial
790.4K viewsMay 21, 2018
YouTubeKevin Stratvert
How to use the Excel XLOOKUP function | Microsoft
0:58
How to use the Excel XLOOKUP function | Microsoft
2.6K viewsFeb 1, 2021
YouTubeMicrosoft Helps
10:50
Excel function VLOOKUP returns #N/A, why ? 4 examples
110.9K viewsSep 23, 2018
YouTubeExcel Exercice
30:46
Excel: VLOOKUP, HLOOKUP & XLOOKUP Fully Explained
12.7K viewsMar 23, 2021
YouTubeJohn Day Q&A
0:54
How to use the XLOOKUP function in Microsoft Excel
247.7K viewsMar 12, 2021
YouTubeMicrosoft 365
4:09
VLOOKUP / XLOOKUP in Power Query
18.2K viewsMar 2, 2021
YouTubeExcel with AG
19:53
Excel XLOOKUP Function Examples - 8 Useful XLOOKUP Examples
37.9K viewsFeb 24, 2020
YouTubeComputergaga
3:33
Xlookup In Excel: Explained In 3 Minutes
1.4M viewsSep 10, 2019
YouTubeExcel Campus - Jon
0:19
Excelhacks101 | Daily Excel Tips on Instagram: "XLOOKUP in Excel‼…
192.1K views9 months ago
Instagramexcelhacks101
6:59
Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)
1.4M viewsSep 12, 2019
YouTubeLeila Gharani
6:45
XLOOKUP vs VLOOKUP in Excel - What's the Difference?
153.5K viewsOct 5, 2020
YouTubeGoSkills.com
4:01
XLOOKUP Create a Multi Column Non-Contiguous Return Array
17.8K viewsNov 18, 2020
YouTubeChester Tugwell
20:48
XLOOKUP Complete Tutorial in Excel (+ Hidden Tricks)
376.2K viewsJan 7, 2020
YouTubeMyOnlineTrainingHub
13:34
How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)
3.9M viewsNov 28, 2019
YouTubeLeila Gharani
3:00
HOW TO USE XLOOKUP LOOKUP BOTH WAYS (HORIZONTAL & VE…
14.2K viewsFeb 2, 2021
YouTubeExcel in a Minute
29:23
What Xlookup Can Do For You ? Xlookup Tutorial - Xlookup in Exc…
1M viewsDec 7, 2020
YouTubeDeepak EduWorld
4:04
Excel Two-Way XLOOKUP - How to use XLOOKUP with two criteria in …
132.2K viewsMay 13, 2021
YouTubeChris Menard
1:50
XLOOKUP or VLOOKUP & Dynamic Arrays to Deliver Table of Lookup …
40.1K viewsOct 11, 2019
YouTubeexcelisfun
3:39
XLOOKUP VS INDEX-XMATCH BY EXCEL IN A MINUTE
16.2K viewsJul 19, 2021
YouTubeExcel in a Minute
3:41
How to use Xlookup with not found value in excel
9.6K viewsFeb 10, 2021
YouTubeMS Excel Skills
3:14
How to Add Xlookup Function In MS Excel (2007 - 2019)
111.7K viewsAug 8, 2020
YouTubeTech NM Acharya
38:48
XLOOKUP Excel Tutorial
43.9K viewsJul 31, 2020
YouTubeLearn Skills Daily
4:52
Excel - XLOOKUP Formula
402 viewsApr 23, 2023
YouTubeSimple Tutorials
21:04
10 Advanced XLOOKUP Tips & Tricks
64.5K viewsNov 7, 2023
YouTubeChandoo
See more videos
Static thumbnail place holder