Assign the value in a Cell when two other cells in two columns contain the same text

Hello Everyone,

the title is probably a bit confusing, but I will make it clear what I am struggling with. I have three very long columns, two are about names and the third about location as below:

Column1....Column blank..Clumn2...Column3
Karen...............................Karen......London
Karen...............................Jack.........Bath
Jack..................................Amy.........New York
Jack
Karen
Karen
Amy
Amy
Amy
Amy

I am looking for a formula I can drop down and that basic allow me to assign the text in Column 3 into the Column Blank according to Column 1. The result should be like:

Column1...Column blank...Column2....Column3
Karen........London...........Karen.........London
Karen........London...........Jack............Bath
Jack...........Bath...............Amy............New York
Jack...........Bath
Karen........London
Karen........London
Amy...........New York
Amy...........New York
Amy...........New York
Amy...........New York

Hope it makes sense, and thanks in advance

Carmine

Carmine, Good morning.

The ZBOR formula works perfectly.

Just put it at B1 and copy down.

Take a look at an example I did for you using a ZBOR formula.
Is it what you want?

Use it at B2
=IFERROR(VLOOKUP(A2,$C$2:$D$20,2,FALSE),"")

Tell us if it worked for you.

Carmine,

The formula was indicated for you by ZBOR, based on your information, and now you gave us a model where a formula works prfectly.

When you say:"...In the original document I have some spaces between C and D..."

What it means exactly?

Is you range from C to D or from C to other column, example, H ?

What´s your real range?
What´s a column with your desired information?

Carmine,

...............thanks for the feedback.

You're always welcome!