View original (French)

Excel dropdown list formula

filousaxo Posted messages 145 Registration date   Status Member Last intervention   -  
JCB40 Posted messages 3068 Registration date   Status Member Last intervention   -

Hello,

In an Excel workbook I have one worksheet named pdg and another named liste villes.

In the sheet liste villes, I have two columns: A for cities and B for postal codes.

In the pdg sheet, cell B5 contains a formula that looks up in the liste villes sheet the city that corresponds to the postal code entered in cell F5 of the pdg sheet.

My formula is: =RECHERCHEX(F5; 'liste villes'!B:B;'liste villes'!A:A;"").

My formula works.

I have a problem because some postal codes are attributed to several cities. Example: 95450 for the cities ableige and commeny, condecourt, la villeneuve st martin and le perchay.

What can I do please?

Is it possible to have a formula that, for example, when I encounter this problem, provides me a drop-down list with all cities assigned to the postal code entered in F5 of the pdg sheet?

Thanks for your feedback,

Best regards,

Filousaxo

1 answer

  1.
    JCB40 Posted messages 3068 Registration date   Status Member Last intervention   479
     
    Hello

    An example of the file with 4:5 lines would be very useful

    Best regards
    0