All
Search
Images
Videos
Maps
News
More
Shopping
Flights
Travel
Notebook
Report an inappropriate content
Please select one of the options below.
Not Relevant
Offensive
Adult
Child Sexual Abuse
Length
All
Short (less than 5 minutes)
Medium (5-20 minutes)
Long (more than 20 minutes)
Date
All
Past 24 hours
Past week
Past month
Past year
Resolution
All
Lower than 360p
360p or higher
480p or higher
720p or higher
1080p or higher
Source
All
Dailymotion
Vimeo
Metacafe
Hulu
VEVO
Myspace
MTV
CBS
Fox
CNN
MSN
Price
All
Free
Paid
Clear filters
SafeSearch:
Moderate
Strict
Moderate (default)
Off
Filter
exceljet.net
Index and match on multiple columns
To lookup a value by matching across multiple columns, you can use an array formula based on several functions, including MMULT, TRANSPOSE, COLUMN, and INDEX. In the example shown, the formula in H4 is: {=INDEX(groups,MATCH(1,MMULT(--(names=G4),TRANSPOSE(COLUMN(names)^0)),0))} where "names" is the named range C4:E7, and "groups" is the named ...
May 11, 2024
Microsoft Excel Excel Tips and Tricks
25:38
Top 20 Microsoft Excel Tips & Tricks
YouTube
Kevin Stratvert
866.8K views
Oct 23, 2020
2:07:11
30 Essential Excel Tips and Tricks for 2024 - Excel Productivity Tutorial
YouTube
Simon Sez IT
99.2K views
Jan 9, 2024
50:17
50 Ultimate Excel Tips and Tricks for 2020
YouTube
Sele Training
1.9M views
Mar 17, 2020
Top videos
6:17
How to Compare Two Columns in Excel (for matches & differences)
trumpexcel.com
Aug 13, 2018
6:25
How to Match Data in Excel
wikiHow
118.5K views
Apr 23, 2024
5:16
Excel: Compare two columns for matches and differences
ablebits.com
Apr 27, 2023
Microsoft Excel Excel Formulas
12:29
Excel Formulas and Functions Tutorial
YouTube
Kevin Stratvert
4M views
Jul 13, 2019
11:43
Excel Formulas and Functions - Tutorial for Beginners (2025)
YouTube
Kevin Stratvert
152.2K views
5 months ago
13:53
🔥 20 Basic Excel Formulas Explained with Examples
YouTube
English with History
1.7K views
Sep 17, 2024
6:17
How to Compare Two Columns in Excel (for matches & differences)
Aug 13, 2018
trumpexcel.com
6:25
How to Match Data in Excel
118.5K views
Apr 23, 2024
wikiHow
5:16
Excel: Compare two columns for matches and differences
Apr 27, 2023
ablebits.com
3:26
Excel: Merge tables by matching column data or headers
Mar 16, 2023
ablebits.com
12:59
Using VLookups to Match Two Data Sets in Excel
81.1K views
Nov 27, 2014
YouTube
TonicaInsight
3:50
How to compare two columns in different Excel sheets using Vlook
…
72.3K views
Jan 5, 2023
YouTube
SpreadCheaters
1:47
How to Find Matches in Excel: Comparing Values Between Two C
…
6 views
7 months ago
YouTube
vlogize
8:41
Match Names on Two Excel Sheets with VLOOKUP – Create Unique I
…
611.3K views
Jan 11, 2022
YouTube
Sharon Smith
14:45
HOW TO: compare two columns in Excel using VLOOKUP
137.9K views
Sep 19, 2019
YouTube
Excel at Work
3:45
Excel: Compare two columns using Vlookup
159.8K views
Sep 30, 2018
YouTube
Prashant Jain
3:02
Two way lookup using VLOOKUP and MATCH in Excel - Office 365
13.3K views
May 6, 2022
YouTube
Find Easy Solution
4:05
Index match with multiple criteria | excel multiple columns match
60.5K views
Oct 29, 2020
YouTube
RJS Info
7:45
Index Match with Multiple Criteria
249.5K views
Jun 1, 2019
YouTube
Ready XL
8:52
How to Do a Multi Column VLOOKUP in Excel (Easy Guide)
10K views
8 months ago
YouTube
Productivity Land
Compare two columns in Excel for matches and differences - Excel B
…
Nov 9, 2024
exceldashboardschool.com
Excel Compare Two Cell Values for Match-Troubleshooting
Sep 17, 2024
contextures.com
2:50
Row Column Lookup with multiple criteria using INDEX and MATCH f
…
27.9K views
May 15, 2022
YouTube
Find Easy Solution
4:20
How to quickly match columns between two different Excel files
16.2K views
Jan 7, 2021
YouTube
Adaptalytics, LLC
4:43
How To Use An Array Formula To Match Values From Two Columns
…
7.2K views
Jun 25, 2015
YouTube
Excel Bytes
2:23
How to Compare Two Columns in Excel For Matches & Differences
…
76.7K views
Sep 2, 2019
YouTube
Excel 10 tutorial
10:15
Find Multiple Matching Values in Excel and Highlight - Match & Hig
…
254.3K views
Jan 16, 2023
YouTube
Sharon Smith
5:45
Excel 2007: how to match data between two columns in excel
41.1K views
Dec 8, 2018
YouTube
ITbird143
15:22
How to Count Matches in Two Columns in Excel
11.5K views
May 25, 2023
YouTube
ExcelDemy
3:16
Using the MATCH Function in Microsoft Excel
94.5K views
Jan 13, 2023
YouTube
Simon Sez IT
7:37
Excel PowerQuery: Match multiple columns between two tables
58.3K views
Aug 14, 2019
YouTube
Your Excel Solution
6:07
Advanced Excel Tutorial - How to compare two columns in Excel fo
…
36.4K views
Jan 19, 2017
YouTube
AZ ChanneL
9:38
Compare two Columns in Excel (for Matches & Differences)
5.7K views
Aug 21, 2021
YouTube
Rath Point
2:57
Compare Two Columns in Excel (for Matches & Differences)
5.6K views
Sep 19, 2021
YouTube
RA Solutions
1:25
How To Compare Columns for Matches in MS Excel | Excel Tutori
…
2.1K views
Aug 8, 2024
YouTube
Guiding Tech
See more videos
More like this
Feedback