Excel Forum
Similar Content
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...
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...



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.