Vlookup for IP

I seem to have VLOOKUP on IP.  It looks up a total wrong IP. I can not figure out why.  I have sheet1 that have the I.P. address in column B that I try to lookup. In sheet2, it has list of IP that I try to lookup and put result of the VLOOKUP into column A of sheet1.  But as you can see the result is not quite right.
Can anyone help?  I attached  the file.
testVLookup.xlsx
tommym121Asked:
Who is Participating?
 
Missus Miss_SellaneusConnect With a Mentor Commented:
Add ", FALSE" at the end of your VLOOKUP like this:

=IFERROR(VLOOKUP($B2,Sheet2!$A$1:$A$161, 1,FALSE),"")
0
 
Zack BarresseConnect With a Mentor CEOCommented:
Yeah, you're doing an approximate match. Make it an exact match, like Missus Miss_Sellaneus says, and it will be just fine. Here is a good resource:

https://exceljet.net/excel-functions/excel-vlookup-function

Regards,
Zack Barresse
0
 
tommym121Author Commented:
Thanks,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.