Forum Discussion

Copper Contributor

Oct 30, 2023

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...

excel

Formulas and Functions

Debie69

Copper Contributor

Oct 30, 2023

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

HansVogelaar

MVP

Oct 30, 2023

Debie69

I hope it'll work with Corse-du-Sud and Haute-Corse (2A and 2B)