Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Highlight, Sort, and Group the Top and Bottom Performers in a List in Excel
Tutorial: How to highlight the rows of the top and bottom performers in a list of data. This allows...
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 773: VLOOKUP to lookup last character in ID Code & Convert Number Text to Number


Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to use the VLOOKUP and RIGHT and "plus zero" "+0" to extract last character in code, use that for the lookup value and return a shift time to a cell. See how to convert a number stored as text to a number.





Got a Question? Ask it Here in the Forum.