Hello,

I need to search alphanumeric contents of column A with the contents of
column c. If a match is found, I want to display the contents of the
adjoining cell in column b.

Ex:
A B C E
e21f Smith 23f4 Miller
r42e Jones 43kf Not found
23f4 Miller e4hh Not found

I should get a result of Miller in col E.

I have an array setup using 'exact' which gives me a True or False answer.
Is there a way to have excel display the contents of the adjoining cell in
col b for all true results?

Any assistance would be appreciated.

Thank you