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.