Quote Originally Posted by jhantoojha View Post
The file I provided you is meant for 200 filehosts and that's enough, I think. If you need more, simply add host and country in Sheet2 and change the formula as suggested before.
Click on F1 in Sheet1. At formula bar, you see the formula as =IFERROR((VLOOKUP(E1,Sheet2!A$1:B$200,2,0)),""). Here B$200 means for 200 filehosts. So if you need for 300 filehosts, change 200 to 300 and hit enter. Now copy the formula at F1 to the end say F8000 or more.
Quote Originally Posted by Lock Down View Post
I made it 8000 like in the original sheet I made so yes a & b on sheet2.

And you are welcome.
It is working fine now......