Guidance please ..
I have two worksheets in my excel file.
Sheet 1 - a list of IP addresses in column E
ex: '1.123.57.208'
Sheet 2 - a list of IP address ranges (roughly 11k rows) assigned to a particular country in columns A, B & C respectfully
ex: '16.777.216' | '17.367.039' | 'AUSTRALIA'
What I'd like to do is add a new column (Column F) to sheet 1 with the location/country match for the IP address range in sheet 2.
My assumption is that a VLOOKUP would work here, but i'm struggling with he exact formula. Any assistance is much appreciated.
I have two worksheets in my excel file.
Sheet 1 - a list of IP addresses in column E
ex: '1.123.57.208'
Sheet 2 - a list of IP address ranges (roughly 11k rows) assigned to a particular country in columns A, B & C respectfully
ex: '16.777.216' | '17.367.039' | 'AUSTRALIA'
What I'd like to do is add a new column (Column F) to sheet 1 with the location/country match for the IP address range in sheet 2.
My assumption is that a VLOOKUP would work here, but i'm struggling with he exact formula. Any assistance is much appreciated.
