Learn Excel Episode 872: VLOOKUP Not Working

Posted in Companies, Podcasts on October 23, 2008



Janet wonders why her VLOOKUPs are not working in certain cases. If your key field contains a mix of numbers and text that looks like numbers, then the VLOOKUP won't work. Episode 872 shows how to use the TEXT function to intermittently solve the problem and another method to reliably solve the problem.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, VLOOKUP, custom format