One solution would be to have both the short and long Area values in your .csv file, so it will find an answer either way if you do the lookup for both the original dashboard and the drilldown. This would work for both the short and long Area names. Also, this would be better than using a eval/case statement, as eval/case would essentially remove the general flexibility of a lookup as values are added/changed/deleted in the .csv file, since they would also have to be managed in the eval/case. My assumption here is that there isn't some other mitigating factor that I'm not aware of that would preclude using this approach.
lookup .csv file:
Area1 Area2
United States US
United Kingdom UK
US United States
UK United Kingdom
... View more