Sounds like a classic vlookup
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Sounds like a classic vlookup

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    It sounds like you already have a large list of what IP addresses match with hotmail, yahoo, etc. If not, you can sort some recent lists by IP address and make a table from there. The listing with the IP addresses and corresponding providors becomes your vlookup table.

    Then, next to each IP address for that day, you will have a copy of a formula something like this:

    =vlookup(sheet1!:a1[containing an IP address you want to match],IPTable[which is on another sheet or in another file and reused every day],2[return second column data, the matching hotmail or yahoo],options)

    I'm not sure if IP addresses are all clustered together for a particular service. If they are, set the option to match the nearest entry.

    If IP addresses for a service are not clustered together, use exact matching. In that case, put the vlookup inside an IF statement. Make the IF statement return some value like "n/a" if the IP address is not in your table yet.

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    oops, belong under allornothing's post

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com