YTL Excel #113: VLOOKUP RIGHT 5 characters only
Loading...
Loading...
1,639
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (4)
-
Wow, this was really helpful, thanks a ton. However, I was wondering how to extract different numbers of characters in Vlookup using the left, mid and right functions? In this one you are extracting only 5 characters but I believe you might have posted a video where you explain how to extract in Vlookup and Hlookup specisic numbers of characters using left,mid and right? If yes please let me know their trick numbers. Thank you.
Loading...
3:21
YTL Excel #112: VLOOKUP Problem (Sort Ascending)by ExcelIsFun3,329 views- 4:05
YTL Excel #114: Copy Table & Name to New Workbookby ExcelIsFun1,276 views
- 4:40
YTL Excel #129: Zip Code, VLOOKUP & TEXT functionsby ExcelIsFun3,823 views
- 10:55
Excel Magic Trick 334: VLOOKUP & Data Validation for Invoiceby ExcelIsFun32,346 views
- 5:31
MS Excel - Using VLOOKUP and Named Rangesby thirdfoundation2,214 views
- 4:54
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup valuesby ExcelIsFun36,357 views
- 3:51
VLOOKUP Text 01by JulepWithMint1,002 views
- 9:54
CCA Excel 7a - Left, Right, Mid, And, Or, Year, Today, Vlookupby MrLehai6,066 views
- 3:04
Excel Magic Trick 555: IF & VLOOKUP Formula for Two Distinct Commission Calculationsby ExcelIsFun8,311 views
- 3:38
Excel Lookup Series #3: VLOOKUP Function 3rd Exampleby ExcelIsFun62,319 views
- 4:36
Excel Magic Trick 640: VLOOKUP and Conditional Formatting to Highlight Row with Low Rankby ExcelIsFun5,394 views
- 3:38
YTL Excel #115: Time Delayed Formula TODAY & IF functionsby ExcelIsFun2,712 views
- 4:11
Excel Magic Trick 318: MID Text (substring) VLOOKUP Troubleby ExcelIsFun4,340 views
- 3:30
YTLE#62: VLOOKUP INDIRECT & Lookup in Different Tablesby ExcelIsFun6,912 views
- 5:03
Excel Lookup Series #4 PART 2: VLOOKUP Function 4th Exampleby ExcelIsFun40,215 views
- 6:23
VLOOKUP Between Separate Workbooks and Worksheets in Excelby ExcelisHell89,971 views
- 4:49
YTL Excel #123: Array Formula To Count E-mailsby ExcelIsFun1,453 views
- 3:56
Excel Magic Trick 684: VLOOKUP 1 item & Add Values from Multiple Rows/Columns - HLOOKUPby ExcelIsFun8,062 views
- 2:07
Excel Magic Trick 408: VLOOKUP MIN Valueby ExcelIsFun2,479 views
- 6:35
Excel Magic Trick 702: VLOOKUP Return Two Values to One Cell or Two Cellsby ExcelIsFun4,004 views
Thank you for posting this helpful video and I am sorry my previous comment is a bit wordy. Anyways, I was wondering how to extract different numbers of characters in Vlookup using the left, mid and right functions when I want to extract different numbers of characters? So if you have posted a video where you explain how to extract different numbers of characters at once using vlookup,hlookup and then inserting left , right and mid functions, please provide the link. Thank you.
megha2788 8 months ago
I do not think I have one for that. Try posting your question to THE best Excel question site:
mrexcel[dot]com/forum
ExcelIsFun 8 months ago
Great video thank you
JohnLarko 3 years ago
Dear JohnLarko,
You are welcome!!
--ExcelIsFun
ExcelIsFun 3 years ago