compare data in two columns

G

Guest

What is the correct formula to use to compare data in column A to see if
there is a match in column B. In column C, just return the value in column A
if there is a match anywhere in column B, otherwise leave blank.
Col A Col B Col C
1234 5555
4321 3457
5555 3241 5555
5241 2319
3457 5361 3457

I have tried Vlookup, If statements, and a few others, but can't seems to
get the correct format. Thank you.
 

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

Top