How to search and replace cells

K

KirillGichunts

Joined
Jul 15, 2012
Messages
1
Reaction score
0
Can you help:

I have two columns of identical data (fairly large data set) where in Column B the data is same as in column A but is in different order, in the third column I need a formula that would: Look for a text in column B, and would return the text corresponding (or match) the text in column A

What I have:

Column A Column B
Bob Bill
Bill Jack
Jack Jospeph
Joseph Robert
Jill Bob
Robert Jack

What I am trying to get:

Column A Column B Column C (formula)
Bob Bill Bob
Bill Jack Bill
Jack Jospeph Jack
Joseph Robert Joseph
Jill Bob Jill
Robert Jack Robert

Can anyone help with this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Contains a Value Cell and Sumif? 4
How to use OFFSET to determine DUPLICATES in a list? 3
CountIf or another function 4
formula for adding cells in different rows and different columns 4
Extract unique values 3
Please Help If statement Data Location!!!!! 1
counting and adding 2
Count text cells based on two criteria 9

Top