Comparing two spread sheets?

Tommy Glad · Mar 26th, 2002, 08:40 AM

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

LeeHitchen · Mar 26th, 2002, 08:48 AM

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

Regards

Lee

Tommy Glad · Mar 26th, 2002, 09:53 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 08:40 AM	#1
Tommy Glad New Member Join Date: Mar 2002 Posts: 2	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

Mar 26th, 2002, 08:48 AM	#2
LeeHitchen New Member Join Date: Mar 2002 Location: England Posts: 26	Sounds like "Vlookup" may provide the solution? Can you be more specific with data layout on spreadsheets? Regards Lee

Mar 26th, 2002, 09:53 AM	#3
Tommy Glad New Member Join Date: Mar 2002 Posts: 2	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