Forum Discussion
Solved
Combining specific data from 2 spreadsheets
Apologies as total newbie - in an ideal world I need the data in spreadsheet 1 (pic 1) to look for a match in spreadsheet 2 (pic 2) and if there is a match, to bring the 5 digit ID code back to sprea...
PhilipTreacy
Super User
Super User
Hi Phil, it worked for 984 results but not for 230 or so. I played around with the fuzzy options but as soon as I did this they tended to be mismatched. Is there any other solution you may be aware of? Thank you so much for your help already!
- PhilipTreacy
Hi nlaauw
If it's not matching that's because the same names don't appear in both columns. Not really sure how you want to get arounds that. Ifd you want to pullan ID from the 2nd table then you need to have the place name match from the 1st table.
If you have places in your 1st table that aren't in the 2nd, you need to add them to the 2nd table with the relevant ID.
Phil