When searching a list for data using lookup functions excel does not match like values because (I assume) the format of the cells is not the same. When the format has been changed to match the other ...