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 and Sort 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 allow...
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...

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.