V lookup not working!

[Ellieprophet]

Hellooo i am working in marketing and trying to remove people from my data selects.

I am using the formula : =VLOOKUP($B2,Sheet2!$A$2:$H$990494,2,FALSE)

However when manually looking it hasn’t picked up all the removes? Everything’s in the right column and around 80% removes are working.

Any help much appreciated!

Thanks,
Ellie

 

[RoryA]

Most likely the ones that are not working don't actually match - perhaps because of leading/trailing spaces, or typos.

 

[Ellieprophet]

Most likely the ones that are not working don't actually match - perhaps because of leading/trailing spaces, or typos.

Hi, Just had a quick look and did find and replace for spaces, dots, etc and still isn’t fully working. It’s there a problem with the formula?

Thank you!

 

[RoryA]

Assuming the ranges are correct, no - which is why it works for most of them. I assume you don't have any names over 255 characters?

I suggest you find one that you think should be working and do a simple equality formula (=B2=Sheet2!A100 for example) to check if they actually match. If that returns FALSE, then you'll need to examine character by character.