VLOOKUP Problem!! Not generating names

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

or

https://www.dropbox.com/s/tn8dv9ivpb...2016.xlsx?dl=0

Hi,

VLOOKUP will only look from left to right. The value you are looking up has to be left of the value you want to return.

For you situation you can use INDEX MATCH.

Try this formula in C2 and copy down.

Please Login or Register  to view this content.

Hope this is helpful.

Cheers

Thanks a lot this worked

I am glad I could be of some assistance.

Cheers