Vlookup tilde

[varunbiswas]

Hi Team,

While referring to one of the other links

http://www.mrexcel.com/forum/excel-questions/493657-vlookup-trouble-tilde-~.html

I got most of my issues solved. But there is this one particular cell that is returning #VALUE! error

Here's the snippet
https://docs.google.com/file/d/0B4E3qiSj4XfIbHhPUHYxM1NhdHc/edit?usp=sharing