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
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