Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Comparing two spread sheets?

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

    Default

    Here is my delema,
    I am a college student and I am trying to compare an excel document from Nationals for my Fraternity with one from my school. The document is a name of Alumni and I am trying to update their addresses through the school. Is there anyway for me to automate the search - taking a name from the Nationals document and getting the info from the one from the school? I need the name from the nationals list and all of the info from the school....
    Hope this makes sense
    Hope you can help
    Thanks
    Tommy

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

    Default

    Sounds like "Vlookup" may provide the solution? Can you be more specific with data layout on spreadsheets?

    Regards

    Lee

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

    Default

    Thanks for the response

    I'm not sure exactly of the format because I am still waiting to atain them. I know that the format from our Nationals is going to have columns that are labled Name, Address, city, state, zip and phone number. I want to take the name out of the first column and search for it from my copy from school. Once I find their name I want all of the information from that row.

    I hope this helps and thanks for your help

Some videos you may like

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
  •