Compare and copy
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
|