A colleague of mine – who is an experienced Excel user – cannot figure out why he is receiving those ugly #N/A Error Messages when he is using the VLOOKUP Function in Excel. After a quick look at his workbook, I spotted the problem! Use the TRIM() Function to Remove Extra Spaces It turns out, […]