vlookup IP addresses

%3CLINGO-SUB%20id%3D%22lingo-sub-1640078%22%20slang%3D%22en-US%22%3Evlookup%20IP%20addresses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1640078%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%202%20tables%20with%20data%20including%20a%20column%20with%20IP%20addresses%20(e.g.%2010.21.53.4)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20do%20a%20simple%20vlookup%20to%20check%20if%20an%20IP%20exists%20in%20the%20second%20table%20and%20return%20it%20exists.%26nbsp%3B%20I%20can%20get%20vlookup%20to%20work%20just%20fine%20on%20another%20column%20containing%20text%20but%20when%20I%20try%20to%20vlookup%20the%20IP%20address%20columns%20it%20just%20doesn't%20work%20at%20all.%3C%2FP%3E%3CP%3EWhat%20am%20I%20missing%3F%26nbsp%3B%20Does%20the%20column%20need%20to%20be%20in%20a%20certain%20format%20e.g.%20text%2C%20number%2C%26nbsp%3B%20currency%2C%20accounting%20etc%3F%3F%3F%3F%3F%3F%3C%2FP%3E%3CP%3EHelp%20its%20driving%20my%20f*cking%20crazy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1640078%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1640100%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%20IP%20addresses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1640100%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F400114%22%20target%3D%22_blank%22%3E%40lfk73%3C%2FA%3E%26nbsp%3BYou%20didn't%20provide%20an%20example%20of%20the%20formula%20and%20data%20that%20don't%20seem%20to%20work.%20The%20attached%20workbook%20contains%20a%20working%20example.%20Perhaps%20it%20enables%20you%20to%20diagnose%20your%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have 2 tables with data including a column with IP addresses (e.g. 10.21.53.4)

 

I'm trying to do a simple vlookup to check if an IP exists in the second table and return it exists.  I can get vlookup to work just fine on another column containing text but when I try to vlookup the IP address columns it just doesn't work at all.

What am I missing?  Does the column need to be in a certain format e.g. text, number,  currency, accounting etc??????

Help its driving my f*cking crazy

2 Replies
Highlighted

@lfk73 You didn't provide an example of the formula and data that don't seem to work. The attached workbook contains a working example. Perhaps it enables you to diagnose your problem.

Highlighted
Worked and I figured out why also. Thanks.