VLOOKUP Problem!! Not generating names

[taj1504]

Hi all,


I've this excel file. There are few worksheets in it. Main one is "Yesterday's DemandTags" worksheet. So I'm trying to fetch "Demand Partner" names from "Yesterday's DemandTags" worksheet to individual Platform worksheets like Cedato,LKQD,VertaMedia,Arena,SpringServe,Optimatic using VLOOKUP. But its not able to find those names showing "#N/A" errors. This is working on 2 or 3 cells like you can check in "Cedato" worksheet "B143" cell. Can anyone please fix this.


Excel File Download Link
https://1drv.ms/x/s!AhSiKNW8SrO0b421fEYuf2yEVHs

 

[Declamatory]

The link doesn't work for me.

 

[taj1504]

The link doesn't work for me.

https://www.dropbox.com/s/tn8dv9ivpbdqu6w/DemandReport-2-12-2016.xlsx?dl=0

 

[Declamatory]

It might just be me but I can't open that either.