Main Profile

At A Glance

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.
Length: 04:04

Contact

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

Want more info about Excel Magic Trick 773: VLOOKUP to lookup last character in ID Code & Convert Number Text to Number? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question