matching entries, a tricky one

[drag-driver]

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.

 

[Aladin Akyurek]

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.

Aladin

 

[AJ]

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

 

[Dave Hawley]

Hi

How about

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

 

[Aladin Akyurek]

Or, indeed, with COUNTIF:

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

Aladin
This message was edited by Aladin Akyurek on 2002-03-26 04:18