VLOOKUP showing error on url

[kalucharan]

Sheet1

SL NO​	URL​	Value​	Country​	Pages​
1​	Seasonal Holidays 2024 Happy Holidays! #GoogleDoodle 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	Seasonal Holidays 2024 Happy Holidays! #GoogleDoodle 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)