Forum Discussion
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...
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?
- 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,
DavidI hope it'll work with Corse-du-Sud and Haute-Corse (2A and 2B)
