I need to compare values in column A to all values in column B and when a match is found enter the corresponding data in column C (same row) into column D. There are 8741 rows in column a, 2708 in column B & C. 0 in column D currently. Please help
A1 B1 C1 D1
x y orange blue
y x blue orange
z z red red
Bookmarks