Is there a way to merge two spreadsheets using an If/Then formula. For example, I have two spreadsheets. One spreadsheet has the city listed. The other has the address. Is there a formula that will merge the two? If "Bakersfield" then use the "Bakersfield address"?
If the city is on sheet1 and the address is on sheet 2 what is the common item on each sheet that can be used to know that the address is for what city?
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Basically, the matching data is the city name. On spreadsheet one, the city name is listed. On spreadsheet two, the entire address is listed. Will that work?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks