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 vl...

excel

Formulas and Functions

Riny_van_Eekelen
Sep 07, 2020
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.
lfk73.xlsx9 KB

Riny_van_Eekelen

Platinum Contributor

Sep 07, 2020

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.

lfk73.xlsx9 KB

lfk73
Brass Contributor
Sep 07, 2020
Worked and I figured out why also. Thanks.
- CognosPunekar
  Copper Contributor
  Jul 26, 2022
  Can you please post your solution I am facing the same issue..lfk73

Forum Discussion

vlookup IP addresses

Resources