Solved

Vlookup for IP

Posted on 2016-10-07
3
94 Views
Last Modified: 2016-10-11
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
0
Comment
Question by:tommym121
3 Comments
 
LVL 11

Accepted Solution

by:
Missus Miss_Sellaneus earned 250 total points
ID: 41834284
Add ", FALSE" at the end of your VLOOKUP like this:

=IFERROR(VLOOKUP($B2,Sheet2!$A$1:$A$161, 1,FALSE),"")
0
 
LVL 14

Assisted Solution

by:Zack Barresse
Zack Barresse earned 250 total points
ID: 41835081
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
 

Author Closing Comment

by:tommym121
ID: 41838425
Thanks,
0

Featured Post

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS excel check if Links exist 5 35
VBA - If Bookmark = "XXBOOKMARKXX" then 15 29
How best to represent data in Excel? 13 27
sumifs excel 2013 3 16
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question