Forum Discussion

foudou's avatar
foudou
Copper Contributor
Jul 08, 2021
Solved

automatic filling of a text of in a cell according to a series of letters of an adjacent cell,

Hello I'm trying to find a formula that allow me to automaticaly fill a cell with name of places (Copenhagen DK or Aarhus DK) according to a series of letters of an adjacent cell. Copenhagen, DK...
excel
  • Lorenzo's avatar
    Lorenzo
    Jul 08, 2021

    Hi foudou 

    You need to create somewhere in your workbook a mapping table as the grey one below

     

     

    Then, according to the above mapping table, formula in B2:

    =VLOOKUP(LEFT(A2,7), D$3:E$6, 2, FALSE)

     Corresponding sample attached

Lorenzo's avatar
Lorenzo
Silver Contributor
Jul 08, 2021

Hi foudou 

You need to create somewhere in your workbook a mapping table as the grey one below

 

 

Then, according to the above mapping table, formula in B2:

=VLOOKUP(LEFT(A2,7), D$3:E$6, 2, FALSE)

 Corresponding sample attached

foudou's avatar
foudou
Copper Contributor
Jul 14, 2021
Youpi ! It works !
Thank you so much
Have a nice day !
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jul 14, 2021
    You're welcome. When you have a minute, there a link to mark as Response on each reply you get => Can help those who search for existing solution. Thanks & Nice day too

Resources