Range Vlookup
in [Functions]
|
Prev: Return cell characters after space
Next: Counting values in an array where value in one column is not null
From: deen on 21 Apr 2010 05:48 Hi Every One, I hope you all are doing well, I required your help to resolve my issue in excel. On single worksheet i have two different sheet name as 1.IP Range 2. Result. Question: EG:IP Range Start IP End IP Area 192.168.1.4 195.182.254.254 AG 10.15.33.10 10.18.56.254 EMEA 10.128.33.5 10.132.40.60 AP Here it will Continued as well. On Result sheet i required result like: IP Area 192.170.30.30 AG 194.168.10.20 AG 10.131.37.20 EMEA 10.170.255.255 NA 10.129.36.8 AP I required result on area column. Here we have more than 50000 IP's but very difficult to find the area. Could any one please help me on this issue. How i can resolve the issue Thanks in advance Deen
From: Jacob Skaria on 21 Apr 2010 07:32
Check your other post in 'General Questions' -- Jacob (MVP - Excel) "deen" wrote: > Hi Every One, > > I hope you all are doing well, I required your help to resolve my > issue in > excel. > > On single worksheet i have two different sheet name as 1.IP Range 2. > Result. > > Question: > EG:IP Range > > Start IP End IP Area > > 192.168.1.4 195.182.254.254 AG > 10.15.33.10 10.18.56.254 EMEA > 10.128.33.5 10.132.40.60 AP > > Here it will Continued as well. > > On Result sheet i required result like: > > IP Area > > 192.170.30.30 AG > 194.168.10.20 AG > 10.131.37.20 EMEA > 10.170.255.255 NA > 10.129.36.8 AP > > I required result on area column. Here we have more than 50000 IP's > but very > difficult to find the area. > > Could any one please help me on this issue. How i can resolve the > issue > > > Thanks in advance > Deen > . > |