VLOOKUP: Vertical Lookup in Excel

Entering numbers as text. Move to the cell where you want the entry and type the numeric value preceding it with an apostrophe, e.g. ‘2006. Excel will treat your entry as text and line it up accordingly. Multi-line cell. If you want to break a line within a … ................
................