Forum Discussion

Debie69's avatar
Debie69
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 sometimes, the result is ok, sometime not.

The formula is

=RECHERCHEX([@Département];Tableau3[Code];Tableau3[Libelle];"Not found";0;1)

 

Could you help me ?

 

excel
Formulas and Functions

3 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 30, 2023

    Debie69 

    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's avatar
      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

Resources