Excel Forum

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.