Forum Discussion
Solved
vlookup IP addresses
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
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.
