Input info if cell doesn't start with "G"

[ianwt]

HI,
I need a macro or formula so that if an input in a cell doesn't start with for example the letter G another cell is automatically populated with a predetermined text, for example Due Date

So if A1 equal G-S then nothing happens, but if A1 equal H-1 then B12 is automatically populated with "Due Date"

Hope that all makes sense.

Ian

[Mallycat]

put a formula in B12 something like this

=if(left(a1,1,1)="G","","due date")

This will work if there is only one condition. If there is more than one condition (looks like there is), then consider using like/match http://www.excel-vba.com/e-formula-index-match.htm