Lookup IP address in range

**evolv12** · 11-22-2011, 04:22 AM

Hi all,

I'm trying to lookup VLAN names for a list of IP addresses. The sheet with VLANs has a start IP and an end IP. I've attached an example of what I'm trying to do.

Regards,
Bart

**nilem** · 11-22-2011, 06:06 AM

Try an UDF (see attachment).

**evolv12** · 11-22-2011, 09:34 AM

This works perfectly, thanks!

**jakng** · 10-03-2014, 01:32 AM

Hello, I am a newbie, how do U get the VLN function to work on my excel file?
Thanks

**zbor** · 10-03-2014, 02:23 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.