Hi All,
Need a help in capturing data from another spreadsheet. I have two files
1. File A (1200 rows)
<tbody>
</tbody>
2. File B ( 300 rows)
<tbody>
</tbody>
Output
I want to compare file A and B by "City" and populate address1/address2/State/Country/Postal in File A
<tbody>
</tbody>
Thanks in advance and please let me know if you have any further questions.
Need a help in capturing data from another spreadsheet. I have two files
1. File A (1200 rows)
Name | Exchange | City | Address1 | Address2 | State | Country | Postal |
Abe John | CBOT | New York | |||||
Mark Twain | CME | Singapore |
<tbody>
</tbody>
2. File B ( 300 rows)
Address1 | Address2 | City | State | Country | Postal |
320 W, 42nd st | New York | NY | US | 10048 | |
140 Governers Lane | Miami | FL | US | 40323 | |
34, financial district | zone2 | Singapore | SG | 324A4 |
<tbody>
</tbody>
Output
I want to compare file A and B by "City" and populate address1/address2/State/Country/Postal in File A
Name | Exchange | City | Address1 | Address2 | State | Country | Postal |
Abe John | CBOT | New York | 320 W, 42nd St | NY | US | 10048 | |
Mark Twain | CME | Singapore | 34, financial district | zone2 | SG | 324A4 |
<tbody>
</tbody>
Thanks in advance and please let me know if you have any further questions.