Hi,

You may want to try the following array formula (Ctrl+Shift+Enter)

Assume you data is in A3:A5 of "sheet 1" and other data is in A3:A5 of
"Names1"

In cell B3 fo sheet 1, enter the following array formula

=if(OR(EXACT(A3,Names1!$A$3:A5),A3))

Regards

"Mary" wrote:

I need to compare to columns of data that are in contained in separate tabs
and when a match is found, then I would like to copy the information in an
adjacent cell to the second tabbed spreadsheet.

What is this type of function called?

Does anyone know if this can be done? I am sure it can be, if I knew where
to look. Excel is so powerful and I just know someone knows how to do this.

Thanks as always appreciate your expertise and assistance!
Mary