software

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

assume the values start in A2 you want to lookup starts in A2 and the values
you want to lookup from starts
in Sheet1!A2 and the adjacent cells are in B
=IF(ISNUMBER(MATCH(A2,Sheet1!$A$2:$A$200,0)),VLOOK UP(A2,Sheet1!$A$2:$B$500,2,0),quot;No
Matchquot;)copy down (change ranges and cells to fit your data)

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Maryquot; gt; wrote in message
...
gt;I need to compare to columns of data that are in contained in separate tabs
gt; and when a match is found, then I would like to copy the information in an
gt; adjacent cell to the second tabbed spreadsheet.
gt;
gt; What is this type of function called?
gt;
gt; Does anyone know if this can be done? I am sure it can be, if I knew
gt; where
gt; to look. Excel is so powerful and I just know someone knows how to do
gt; this.
gt;
gt; Thanks as always appreciate your expertise and assistance!
gt; MaryHi,

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

Assume you data is in A3:A5 of quot;sheet 1quot; and other data is in A3:A5 of
quot;Names1quot;

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

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

Regards

quot;Maryquot; wrote:

gt; I need to compare to columns of data that are in contained in separate tabs
gt; and when a match is found, then I would like to copy the information in an
gt; adjacent cell to the second tabbed spreadsheet.
gt;
gt; What is this type of function called?
gt;
gt; Does anyone know if this can be done? I am sure it can be, if I knew where
gt; to look. Excel is so powerful and I just know someone knows how to do this.
gt;
gt; Thanks as always appreciate your expertise and assistance!
gt; Mary