Multi-Conditional with Wildcards...

Hi everyone, my problem is as follows (can use a formula or VBA code):

I've got a column with client codes (col. B) and another one with material codes (col. C). Both columns mix numbers and text.

First condition: If cells in "B" column equal a specific code ("DA2")

Second condition: AND If the cells in "C" column start with a certain pattern ("30") followed by some other pattern (four random digits, a dash, and two or three more random digits)

THEN a new cell should say "T1", Else it should just copy another cell.


I now it might be a bit hard to visualize, therefore I'm attaching a sample worksheet to simplify my problem.

Cheers,
Kianuz.

This should work I think

Please Login or Register  to view this content.

Try:

=IF(AND(B4="DA2",LEFT(C4,2)="30",ISNUMBER(MID(C4,3,4)+0),MID(C4,7,1)="-",OR(ISNUMBER(MID(C4,8,2)+0),ISNUMBER(MID(C4,8,3)+0))),"TI",D4)

The solutions worked perfectly, I'm grateful for the speed and accuracy with which u guys helped.

I've got one more question however (for a problem I just noticed):

How could I change the formula to say that instead of $B4="DA2", $B4 starts with "DA" (because the above solution should be applied to all clients that start with DA (not in sample file), and I just noticed...)

Thanks again guys!!

Replace $B4="DA2" with LEFT($B4,2)="DA"