I'm trying to return some values from one worksheet to another . I tried using both Vlookup & indexmatch . None of them seems to be working for me .I have attached the spreadsheet for the reference . Thanks in advance !

In Rawdata worksheet , Column Z has " vlookup " & Column " AA" has Index match

I would also like to know whats causing this problem , because this happens for me most of the times .. Am I using incorrect data type ?