I am bored of writing IF statement to replace data with dummy data, please suggest me the quickest way, following is example of what I wanna achieve.
Create a mapping table (load from inline or from Excel) and use ApplyMap to replace the current field with the result.
Applymap is the better option.
See this post for more details Don't join - use Applymap instead
You can also make use of a Lookup() function.
Retrieving data ...