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.
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.