Alternative to IF statement

[guruprem]

Dear Experts,

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.

CurrentFeild  ResultFeild

James     Apple

John        Banana

Sarah      Avpcado

...               ....

[jonathandienst · Accepted solution]

Create a mapping table (load from inline or from Excel) and use ApplyMap to replace the current field with the result.

[Colin-Albert]

Applymap is the better option.

See this post for more details Don't join - use Applymap instead

[reddy-s]

Hi Guruprem,

You can also make use of a Lookup() function.

Thanks,

Sangram.