1 last thing!

Countries:

=IFERROR(LOOKUP(100^100,SEARCH("*"&Sheet2!$A$2:$A$256&"*",K2),Sheet2!$B$2:$B$256),"Other")

Works great except I was a bit naive, its not just the bit after the last dot I need. I found a problem as I had to remove a few conflicting countries. i.e. Burundi. The code is .bi however I had a lot of .biz's. So removed it.

Can you tell me how to make it a rule where it looks for the last dot but only considers the last 2 digits.

Cheers.

I added reputation. Least I can do!