Tony-basaletti
Reputation: 11
How to find and replace multiple values from mapping (key value pairs) in Google Sheets?
I have a sheet with data for rankings for hundreds of people. My data is anonymous, and instead of using the names of the people, I have UID numbers.
I'm trying to find and replace the UID numbers with a mapping that shows, in key-value pairs, which UID corresponds to which person.
Is there a quick way to do this?
Google Sheet sample problem with only 10 people: https://docs.google.com/spreadsheets/d/1dsLpFBNTmhC3ISoYrJFPhEleBo_W5mrK9MSz-V7ZasE/edit?usp=sharing
Upvotes: 1
Views: 1373
Answers (2)
Related Questions
- Google Sheets multiple search and replace from a list
- Find and replace by multiple patterns
- Google Apps Script for Multiple Find and Replace in Google Sheets
- How to find and replace multiple values in Excel at the same time?
- Find and Replace with multiple values for each occurrence (VBA)
- For given Key Value pair find and replace all keys with corresponding values at once in Google Spreadsheet
- find and replace in google sheets
- Google Sheets: Find and Replace different text values
- How to find and replace multiple values in Excel?
- Excel Find and Replace