I'm for a formula that will compare 2 columns and copy an adjacent column if
they match. In the example below, I would compare the EE#s in columns B and
c and if they match, it would copy the name in column A to column D.

A B C D
Name EE# EE# Desired Result
Tom 24 11 Tony
Bill 36 24 Tom
Tony 11 36 Bill