Excel Vlookup Question

[Robertson1995]

I have a vlookup issue that I need help with. I have a spreadsheet that pulls an IP address into column F from another column using the =mid formula. Then the data that it pulls is referenced with vlookup to add a name to the IP address in yet another column.

Vlookup will only work if I add *1 to the end of the =mid formula. The problem Im having is by using =mid some of my IP addresses are shorter than others which adds extra characters.

For example: =mid(H1,12,14) would pull 10.240.125.129 for a 14 digit IP, but if the IP address is 12 digits it would pull 10.240.125.1//.

I can add "//" to my vlookup table for the shorter IP addresses which would solve the problem I think, but the problem is when I add *1 to the =mid on these it doesnt recognize it.

I hope this makes since, I probably made it more complicated than it has to be. Thanks in advance for the help.

 

[Jonmo1]

Try changing the mid formula to

=mid(H1,12,FIND("/",H1)-12)