What formula can I use to compare items in two columns
 

I have two columns of data in seperate spreadsheets. I want to compare the
data in one column with data in the other. If there is a match I want it
noted in some way. If thre is no match I want that noted as well.

What formula can I use to compare items in two columns
 

You can use an adjacent column of formulas:

=isnumber(match(a1,sheet2!a:a,0))

If you see True, there's a match. False means there isn't.



Docgero wrote:

I have two columns of data in seperate spreadsheets. I want to compare the
data in one column with data in the other. If there is a match I want it
noted in some way. If thre is no match I want that noted as well.

--

Dave Peterson

What formula can I use to compare items in two columns
 

Thanks Dave. I did not get the desired results expected.

Perhaps I didn't explain properly what I was trying to accomplish. As
mentioned I have two spreadsheets. I have the same type data (item numbers)
in columns in each sheet. I want to look at the universe of items numbers in
column 2 sheet 1 and see if there is a match on sheet 2 column 2. This will
be an item for item check.

"Dave Peterson" wrote:

You can use an adjacent column of formulas:

=isnumber(match(a1,sheet2!a:a,0))

If you see True, there's a match. False means there isn't.



Docgero wrote:

I have two columns of data in seperate spreadsheets. I want to compare the
data in one column with data in the other. If there is a match I want it
noted in some way. If thre is no match I want that noted as well.

--

Dave Peterson

What formula can I use to compare items in two columns
 

Dave,

I altered your formula slightly and it works. Here is what I did.

=ISNUMBER(MATCH(B5:B1170,'[Book Order - ALPHA.xls]Master List'!$A$2:$A$720,0))

works perfectly.

Thanks again.

Docgeo


"Dave Peterson" wrote:

You can use an adjacent column of formulas:

=isnumber(match(a1,sheet2!a:a,0))

If you see True, there's a match. False means there isn't.



Docgero wrote:

I have two columns of data in seperate spreadsheets. I want to compare the
data in one column with data in the other. If there is a match I want it
noted in some way. If thre is no match I want that noted as well.

--

Dave Peterson

What formula can I use to compare items in two columns
 

I was too lazy to point at another workbook. Glad you got it working.

But I would have guessed you wanted this version:

=ISNUMBER(MATCH(B5,'[Book Order - ALPHA.xls]Master List'!$A$2:$A$720,0))

And drag down

Docgero wrote:

Dave,

I altered your formula slightly and it works. Here is what I did.

=ISNUMBER(MATCH(B5:B1170,'[Book Order - ALPHA.xls]Master List'!$A$2:$A$720,0))

works perfectly.

Thanks again.

Docgeo

"Dave Peterson" wrote:

You can use an adjacent column of formulas:

=isnumber(match(a1,sheet2!a:a,0))

If you see True, there's a match. False means there isn't.



Docgero wrote:

I have two columns of data in seperate spreadsheets. I want to compare the
data in one column with data in the other. If there is a match I want it
noted in some way. If thre is no match I want that noted as well.

--

Dave Peterson


--

Dave Peterson