Find the dynamic value on a table to another table.

[linhmpham]

Dear all,

I kindly request your advice on this matter. My objective is to derive roster values from Table A to Table B. However, Table B does not present exact values in the 'Description' column. Instead, it requires the identification of values that contain specific words within the 'Description' column of Table B.

Table A comprises a column intended for value identification purposes. On the other hand, Table B contains a column titled 'Description' that possesses values corresponding to those in Table A.

Create a new column on table B to : 

- Check the value in Table A which is existed in Table B

- Return "blank" if not found.

[Felipe_Ribeir0 · Accepted solution]

Hi @linhmpham 

You can use the find replace tool to do this:

[linhmpham]

Thanks for your advice :)