VLOOKUP with numbers and text
exceljet.net
VLOOKUP with numbers and text
To use the VLOOKUP function to look up information in a table where the first column contains numbers that are actually text, you can use a formula that concatenates an empty string ("") to the numeric lookup value, coercing it to text. In the example shown, the formula in H3 is: =VLOOKUP(id&"",planets,2,0) where id (H4) and planets (B5:B13 ...
May 9, 2022
Shorts
Advanced VLOOKUP Tricks in Excel | Save Time & Work Smarter
1:01
22.1K views
Advanced VLOOKUP Tricks in Excel | Save Time & Work Smarter
IICA Computer Education
Not all numbers are created equal! If your numbers are stored as text, then you will get errors when trying to do a vlookup on actual numbers. Simple fix 🤯 #excel #justthetips_excel #exceltips #exceltricks
11.9K views
Not all numbers are created equal! If your numbers are stored as text, then you will
excel_justthetips
VLOOKUP Tutorial
How to use the VLOOKUP function in Excel
2:58
How to use the VLOOKUP function in Excel
YouTubeTechOnTheNet
4.9M viewsSep 28, 2018
Excel Vlookup Tutorial - Everything You Need To Know
21:50
Excel Vlookup Tutorial - Everything You Need To Know
YouTubeExcel Campus - Jon
2.8M viewsAug 15, 2019
How to use VLOOKUP in Excel
1:01
How to use VLOOKUP in Excel
YouTubeMicrosoft 365
3.8M viewsNov 25, 2019
Top videos
How to do Vlookup Formula for Multiple Columns in Single Formula
How to do Vlookup Formula for Multiple Columns in Single Formula
YouTubeExcelskill Corner
232 viewsJul 7, 2024
VLOOKUP Function - Exact match - approximate match - Data validation - with examples
11:33
VLOOKUP Function - Exact match - approximate match - Data validation - with examples
YouTubeTips & Tricks ZOne
185 views7 months ago
Using VLOOKUP in Excel to Find Data In a List
4:08
Using VLOOKUP in Excel to Find Data In a List
YouTubeIQ Accounting Solutions
104.2K viewsApr 27, 2018
VLOOKUP Examples
How to use VLOOKUP in Microsoft Excel
2:38
How to use VLOOKUP in Microsoft Excel
YouTubeMicrosoft 365
2.7M viewsApr 27, 2021
VLOOKUP in Excel | Step-by-Step Tutorial for Beginners
5:43
VLOOKUP in Excel | Step-by-Step Tutorial for Beginners
YouTubeKevin Stratvert
1.4M viewsOct 2, 2024
VLOOKUP in Excel | Tutorial for Beginners
32:09
VLOOKUP in Excel | Tutorial for Beginners
YouTubeKevin Stratvert
2.4M viewsMar 10, 2021
How to do Vlookup Formula for Multiple Columns in Single Formula
How to do Vlookup Formula for Multiple Columns in Single Formula
232 viewsJul 7, 2024
YouTubeExcelskill Corner
VLOOKUP Function - Exact match - approximate match - Data validation - with examples
11:33
VLOOKUP Function - Exact match - approximate match - Data validati…
185 views7 months ago
YouTubeTips & Tricks ZOne
Using VLOOKUP in Excel to Find Data In a List
4:08
Using VLOOKUP in Excel to Find Data In a List
104.2K viewsApr 27, 2018
YouTubeIQ Accounting Solutions
How to use VLOOKUP Function with Multiple Criteria and Lookup Value in Microsoft Excel
7:49
How to use VLOOKUP Function with Multiple Criteria and Lookup Valu…
4.3K viewsJul 2, 2019
YouTubeTechnical Portal
VLookup tricks with Sum and Match Functions Microsoft Office 365
8:48
VLookup tricks with Sum and Match Functions Microsoft Office 365
13.1K viewsFeb 7, 2022
YouTubeInIT Learning
How to use VLOOKUP & XLOOKUP in excel multiple sheets? | 2025
5:34
How to use VLOOKUP & XLOOKUP in excel multiple sheets? | 2025
11 months ago
YouTubeSMARTSPAN
Vlookup in excel
3:41
Vlookup in excel
60 viewsMay 16, 2021
YouTubeHow to ?
1:01
How to use VLOOKUP in Excel
3.8M viewsNov 25, 2019
YouTubeMicrosoft 365
12:14
Excel VLOOKUP With Multiple Workbooks
3.6M viewsMar 19, 2016
YouTubeMaxwell Stringham
6:30
VLOOKUP & HLOOKUP in Excel Tutorial
730.8K viewsMay 21, 2018
YouTubeKevin Stratvert
32:09
VLOOKUP in Excel | Tutorial for Beginners
2.4M viewsMar 10, 2021
YouTubeKevin Stratvert
2:38
How to use VLOOKUP in Microsoft Excel
2.7M viewsApr 27, 2021
YouTubeMicrosoft 365
6:23
Vlookup with Duplicate Entries
77K viewsMay 1, 2020
YouTubeMyexcelacademy
2:16
Excel VLOOKUP in 2 minutes
11.8K viewsOct 19, 2020
YouTubeExcel Level Up
2:58
How to use the VLOOKUP function in Excel
4.9M viewsSep 28, 2018
YouTubeTechOnTheNet
7:40
VLOOKUP Return Multiple Matching Rows and Columns
187K viewsNov 13, 2019
YouTubeExcel University
3:45
EXCEL VLOOKUP from Another SHEET! | How to VLOOKUP in Excel
747.5K viewsJan 2, 2020
YouTubeOnline Training for Everyone
1:14
Vlookup in Excel between multiple Sheets
115.9K viewsOct 30, 2020
YouTubeMyExcelOnline.com
4:06
VLookup to Return an Entire Row
46K viewsMar 22, 2020
YouTubeThe Excel Cave
15:20
How to Use VLOOKUP to Compare Two Lists
1.1M viewsApr 28, 2021
YouTubeSimon Sez IT
7:08
VLookup on Multiple Sheets in Excel
301K viewsDec 16, 2019
YouTubeSyed Shah Zahurullah Hussaini
4:32
Fix Excel VLOOKUP #N/A errors
83.2K viewsOct 22, 2020
YouTubeExcel Level Up
2:17
Vlookup in Multiple Sheets- Easy method
230.2K viewsAug 10, 2014
YouTubeexcel
10:21
Use VLOOKUP to cross reference your data in Excel
30.9K viewsMay 5, 2019
YouTubeEssential Excel
3:13
How To Use VLOOKUP Across Multiple Tables In Excel
7.3K viewsJul 6, 2021
YouTubeExcel Bytes
8:22
How to Combine 2 Excel Workbooks Using VLOOKUP
1.5M viewsAug 13, 2012
YouTubeDanny Rocks
4:34
How to VLookup in Differrent Workbook
315.2K viewsNov 29, 2019
YouTubeSyed Shah Zahurullah Hussaini
8:30
Excel: Combining Vlookup and Match Functions
106.3K viewsFeb 28, 2016
YouTubeMike Thomas
9:52
How to use Excel VLOOKUP on same Worksheet
35.3K viewsAug 12, 2017
YouTubeNadim Hossain
See more videos
Static thumbnail place holder