Comparing two spread sheets?
Manage your personal finances 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

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