tommym121
asked on
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
Can anyone help? I attached the file.
testVLookup.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER