Forum Discussion
Debie69
Oct 30, 2023Copper Contributor
Excel Problem with RECHERCHEX function
Hi, I'm looking face issue with RECHERCHEX function. I have a following table with a code column. The next column should be filled with a label. My reference table is on another sheet. But someti...
HansVogelaar
Oct 30, 2023MVP
Set the horizontal alignment of the Département column to General.
Are the department codes still left-aligned? That would indicate that they are text values although they look like numbers.
Now do the same for the Code column in Tableau3. What do you see there?
Debie69
Oct 30, 2023Copper Contributor
ok solved. It was come from my column department was a result of another column of postal code with a formula like this =left(PostalCode, 2) so the result was in text....so I add ENT before and it works !!!!!
THanks a lot,
David
THanks a lot,
David
- HansVogelaarOct 30, 2023MVP
I hope it'll work with Corse-du-Sud and Haute-Corse (2A and 2B)