1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel help while working with URLs

Discussion in 'Black Hat SEO Tools' started by ppcmaster, Mar 23, 2012.

Tags:
  1. ppcmaster

    ppcmaster Supreme Member

    Joined:
    Dec 26, 2008
    Messages:
    1,492
    Likes Received:
    161
    Occupation:
    Article writing, link wheel, link building, etc
    Location:
    Lowell, MA
    Home Page:
    So this is my first post from a series of 'how to' posts that I am going to develop for BHW. I made this post to help anyone who wants to start using VLOOKUP in excel and doesn't know where to start. I have personally benefited from using VLOOKUP function on excel to fetch data from complicated data sets. So I sincerely hope this will benefit you guys.

    I have used a sample scenario to help illustrate better:
    http://www.contentyogi.com/seo-tools/vlookup-for-matching/

    Let me know what you all think and I have more to follow soon ;)

    ppcmaster

    P.S. Anyone looking for specific help in EXCEL can leave me a tutorial request here:
    http://www.contentyogi.com/seo-tools/request-tutorial/

    We will try and get them done ASAP. Thanks!
     
    • Thanks Thanks x 1
    Last edited: Mar 23, 2012
  2. DrEvil123

    DrEvil123 Junior Member

    Joined:
    Dec 31, 2011
    Messages:
    166
    Likes Received:
    141
    Next time give it a thread name like "Tutorial - Excel vlookups".

    I came in here looking to help :)
     
  3. gramalho

    gramalho Newbie

    Joined:
    Mar 15, 2011
    Messages:
    22
    Likes Received:
    1
    nice :) tkx
     
  4. travanx

    travanx Regular Member

    Joined:
    Feb 6, 2012
    Messages:
    354
    Likes Received:
    76
    Home Page:
    Tutorials are always good. Can you make one that shows how to pull information off of a website database using excel?
     
  5. ppcmaster

    ppcmaster Supreme Member

    Joined:
    Dec 26, 2008
    Messages:
    1,492
    Likes Received:
    161
    Occupation:
    Article writing, link wheel, link building, etc
    Location:
    Lowell, MA
    Home Page:
    Sure thing! I just set up a form to collect requests such as yours here:
    http://www.contentyogi.com/seo-tools/request-tutorial/

    Can you leave me a description on what is needed in the form?

    Thanks a bunch..!

    ppcmaster
     
  6. florflor

    florflor Senior Member

    Joined:
    Mar 9, 2008
    Messages:
    822
    Likes Received:
    307
    Excel is great for IM. I use it for text manipulation, filtering and all kinds of stuff all the time.

    Most people only learn Excel in a job though.
     
  7. SweTech

    SweTech Power Member

    Joined:
    Apr 22, 2011
    Messages:
    620
    Likes Received:
    2,608
    Occupation:
    SEO freelancer
    Location:
    Stockholm, Sweden
    • Thanks Thanks x 1