finding matching cells (Excel 2007)
 

COL A has 1,313 cells whose contents look like this:

107211009-1
114650003-4
122413021-6

COL B has 987,601 cells whose contents look like this:

008100465-2 01 58.86
008100465-2 02 58.86
008100493-7 01 16.12

How do I find the cell(s) in COL B whose eleven left-most characters
match the contents in the cells in COL A?

finding matching cells (Excel 2007)
 

I suppose this would do it:
=IF(A1=LEFT(B1,11),"Match","")

Do you need a macro?

Ryan---
--
RyGuy


"gcotterl" wrote:

COL A has 1,313 cells whose contents look like this:

107211009-1
114650003-4
122413021-6

COL B has 987,601 cells whose contents look like this:

008100465-2 01 58.86
008100465-2 02 58.86
008100493-7 01 16.12

How do I find the cell(s) in COL B whose eleven left-most characters
match the contents in the cells in COL A?

finding matching cells (Excel 2007)
 

another way:

=IF(ISERROR(MATCH(LEFT(B1,11),$A$1:$A$1313,)),""," match")

then use autofilter if need be

On 6 Mar, 07:02, gcotterl wrote:
COL A has 1,313 cells whose contents look like this:

107211009-1
114650003-4
122413021-6

COL B has 987,601 cells whose contents look like this:

008100465-2 *01 * * * * 58.86
008100465-2 *02 * * * * 58.86
008100493-7 *01 * * * * 16.12

How do I find the cell(s) in COL B whose eleven left-most characters
match the contents in the cells in COL A?