Without seeing the workbook, it's impossible to know for certain, but my first thought is that the lookup values are not quite the same. "Chicago" and "Chicago " are not equivalent in Excel, for example. Check lookup list and lookup values to make sure that one of them doesn't have trailing spaces. hth