u/Gouken

The challenge sounds simple, but I'm having trouble finding a solution. To all excel prodigies, this should be easy peasy.

I have a Master sheet full of model numbers (Let's call this C1) in column 1.

I have a Vendor sheet full of C1 model numbers, and a newer replacement C2 model numbers.

The challenge is that I need to use the Master Sheet, search the Vendor Sheet, and any old models are replaced with the new models.

Example:

Master Sheet:

Column 1:
A

B

C

D

Vendor Sheet:

Column 1: | Column 2:

A | Z

B | Y

C | X

D | W

What will happen is the Master Sheet will update to the following:

Z

Y

X

W