Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a field in that i have numbers like 1704,1705.. etc.
Now i need to get names instead of numbers.
For e.g. 1704 should be Germany.
I have written if(Match(field,'1704','Germany'),Field).
But this is expression is not working and getting number only.
Can you please tell me how to achieve this.
Thanks,
Bharat
Perhaps this?
if(Match(field,'1704'),'Germany',Field)
Or
Pick(Match(field,'1704','1705'), 'Germany', 'India').
Perhaps this?
if(Match(field,'1704'),'Germany',Field)
Or
Pick(Match(field,'1704','1705'), 'Germany', 'India').