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