Join two tables and replacing values in one table

VanG

Table #1

Yellow	Null
Green	Null
Blue	Null
Black	Null
Grey	Null

Table #2

Black	1.99
Grey	1.79

I want to join these tables so that Black & Grey in table one are replaced by values in Table 2. I was able to do it via the join multiple tool but for some reason it changed the order of the values. I need the order to stay the same.

Yellow	Null
Green	Null
Blue	Null
Black	1.99
Grey	1.79

bpatel

hi @VanG ,

you can use the find and replace function to append the matched values.i hope this helps!

join and replace.yxmd