# Replace with lookup

**URL:** <https://community.easymorph.com/t/replace-with-lookup/3356>\
**Category:** General Q&A\
**Created:** [January 25, 2022, 4:58pm UTC](https://community.easymorph.com/t/replace-with-lookup/3356 "2022-01-25T16:58:59Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![thomas](https://community.easymorph.com/user_avatar/community.easymorph.com/thomas/32/2349_2.png) [@thomas](https://community.easymorph.com/u/thomas)\
**Post date:** [January 25, 2022, 4:58pm UTC](https://community.easymorph.com/t/replace-with-lookup/3356/1 "2022-01-25T16:58:59Z")

</div>

Hello,

I have a bug with Replace with lookup.  
If you create some values with create lists, like

H  
H  
A  
I

Some values are replaced with some kind off concatenation of all values of the lookup table. Bug disappear if you truncate the lookup table to 3 values for example.

 ![Capture d’écran 2022-01-25 175827](https://community.easymorph.com/uploads/default/original/2X/d/d19e28b232637171d5f6b72a7453e7a6a733bd80.png)

 ![Capture d’écran 2022-01-25 175720](https://community.easymorph.com/uploads/default/original/2X/2/2cccb69fe8149cd29484962c9f332695a3872ded.png)

[valeurs replace VBTYP.xlsx](https://community.easymorph.com/uploads/short-url/mgyyrbBN9HrnugOW2K2FmTPjo8p.xlsx) (10.4 KB)

---

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [January 25, 2022, 6:33pm UTC](https://community.easymorph.com/t/replace-with-lookup/3356/2 "2022-01-25T18:33:39Z")

</div>

The "Replace with lookup" action works correctly. Please read here how it works: [REPLACE WITH LOOKUP [EasyMorph Help]](https://help.easymorph.com/doku.php?id=transformations:replacewithlookup)

What you need is the ["Lookup" action](https://help.easymorph.com/doku.php?id=transformations:lookup). See the example below:

[lookup.morph](https://community.easymorph.com/uploads/short-url/vU6pamn4aPxFp2atb2QHTxOvx3G.morph) (3.3 KB)

 ![image](https://community.easymorph.com/uploads/default/original/2X/8/8cc83fea63814a9ade49a18e4d4dfa52788c41c1.png)

---

<div class="post-metadata">

**Author:** ![thomas](https://community.easymorph.com/user_avatar/community.easymorph.com/thomas/32/2349_2.png) [@thomas](https://community.easymorph.com/u/thomas)\
**Post date:** [January 26, 2022, 7:43am UTC](https://community.easymorph.com/t/replace-with-lookup/3356/3 "2022-01-26T07:43:58Z")

</div>

My bad !  
I did not notice the subtility of "replace with lookup" 😅

Many thanks !

---

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [January 26, 2022, 10:26am UTC](https://community.easymorph.com/t/replace-with-lookup/3356/4 "2022-01-26T10:26:10Z")

</div>

You're welcome!
