VLOOKUP showing error on url

[kalucharan]

Sheet1

SL NO​	URL​	Value​	Country​	Pages​
1​	Google Search the world's information, including webpages, images, videos and more. Google has many special features to help you find exactly what you're looking for. www.google.com	8​	US​	23​
2​	Facebook - Log In or Sign Up Create an account or log into Facebook. Connect with friends, family and other people you know. Share photos and videos, send messages and get updates. www.facebook.com	102​	UK​	8500​
3​	Amazon.com: Online Shopping for Electronics, Apparel, Computers, Books, DVDs & more Free delivery on millions of items with Prime. Low prices across earth's biggest selection of books, music, DVDs, electronics, computers, software, apparel & accessories, shoes, jewelry, tools & hardware, housewares, furniture, sporting goods, beauty & personal care, groceries & just about... www.amazon.com	56​	Germany​	400​

Sheet2

SL No	Domain	Value	Expected Result Value
1	Amazon.com: Online Shopping for Electronics, Apparel, Computers, Books, DVDs & more Free delivery on millions of items with Prime. Low prices across earth's biggest selection of books, music, DVDs, electronics, computers, software, apparel & accessories, shoes, jewelry, tools & hardware, housewares, furniture, sporting goods, beauty & personal care, groceries & just about... www.amazon.com	=VLOOKUP(B2,Sheet1!A1:E4,3,0)	56
2	Google Search the world's information, including webpages, images, videos and more. Google has many special features to help you find exactly what you're looking for. www.google.com		8
3	Facebook - Log In or Sign Up Create an account or log into Facebook. Connect with friends, family and other people you know. Share photos and videos, send messages and get updates. www.facebook.com		102

As you can see I have entered the Vlookup formula to get the Expected Result Value BUT it is showing #NA.
Please help what I am missing in the vlookup formula?

 

[jasonb75]

The url is in column B, not column A.

=VLOOKUP(B2,Sheet1!$B$1:$C$4,2,0)