Forum Discussion
Solved
IF(OR(reconzige only first characters...)
Hi All, Is it possible to use an IF Argument only to recognise the first consistent part of a cell content(text) when the cell content slightly varies at the end? =IF(OR(E2="PAYMENT TO NRMA...
As a variant:
If it's always the first 20 characters that are the same, then this formula works just fine.
=IF(LEFT(E2,20)="payment to nrma 2004",D2,"")If you are not sure where in the text the particular text string may be, try this:
=IF(SEARCH("payment to nrma 2004",E2),D2,"")
As a variant:
If it's always the first 20 characters that are the same, then this formula works just fine.
=IF(LEFT(E2,20)="payment to nrma 2004",D2,"")
If you are not sure where in the text the particular text string may be, try this:
=IF(SEARCH("payment to nrma 2004",E2),D2,"")