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 · Accepted solution]

hi @VanG ,

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

[grazitti_sapna]

Hi @VanG , try this

Thanks.

Alternate Solution

[PhilipMannering]

The easiest way is to use the Find Replace Tool. See attached.