I have two spreadsheets. Spreadsheet A has 2,074 values on it. Spreadsheet B has 7,182 lines on it. Spreadsheet A contains a list of Cities, and Spreadsheet B has a list of zip codes. Sometimes multiple Zip Codes can be used for one City, and sometimes multiple Cities can be used for one Zip Code.
I need someone to:
- Look at line 1 of spreadsheet A
- Find all the times it is referenced in Spreadsheet B
- Paste value from Spreadsheet A into corresponding line of Spreadsheet B
- When it's over, Spreadsheet A should have all corresponding values
This is time sensitive, please place your bids accordingly. I've attached the 2 spreadsheets and filled out the first two lines as an example