When doing a vlookup, I'm searching for the the name
"Allianz~" from the list against a set of data which contains this name. It
won't return any values. However, when I remove the "~" from data table, it
returns a value. Why does this happen, as I am searcing for a constant, and
it appears to be returning when the cells are different? Thanks.