Thanks:  0
Likes:  0

# Thread: matching entries, a tricky one

1. My problem is such i have an entry in a colum "2690 - L 6MT1 REG" i want to be able to compare the first 4 digits with a number in another colum and return the value true or false depending on wither they are matched.

2. On 2002-03-26 03:52, drag-driver wrote:
My problem is such i have an entry in a colum "2690 - L 6MT1 REG" i want to be able to compare the first 4 digits with a number in another colum and return the value true or false depending on wither they are matched.
=ISNUMBER(MATCH(LEFT(A1,4)+0,B:B,0))

Substitute the true range in B for B:B.

3. This should do the trick

=IF(LEFT(A1,4)+0=C1,TRUE)

The LEFT(A1,4) extracts the first four characters.
The +0, converts it to number format (LEFT produces text by default)
C1 is where I put the four digit value by itself
Then there's just a bog standard IF around it.

Rgds
AJ

4. Hi

=IF(COUNTIF(\$C\$1:\$C\$600,LEFT(A1,4)),TRUE)

5. Or, indeed, with COUNTIF:

=COUNTIF(B:B,LEFT(A1,4)+0)>0

[ This Message was edited by: Aladin Akyurek on 2002-03-26 04:18 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•