Automatically adding Mr or Ms to male/female

I have a list of data some with people titles, others with it missing. what i plan on doing is

D is the collum for title some are entered others are not. collum G has male and female already filled in.

is there a code to say if D is empty then look at G if it is female enter Ms in collum D and if male enter Mr in collum D.

Thanks

thanks for the code part. unfortunatly i cannot arrange the empty (blank) cells at the top as the sheet is being used for calucations.

can i not use a IF statement.

IF an empty/black cell is found then use the formula, if the cell has any information move down tot he next row?

i dont see a problem put the formula in the first cell in col d in the row that data starts
so say first row is 5 change formula to match row
=IF(G5="male","Mr","Ms")
then drag down it will just over write whats there
so if d20 already had Mr in it it would just be replaced by Mr anyway
once done select all data in row d /copy paste back as special/values to remove formulas.

Hi!

How about this?

=if(a4="mr.","male","")&if(a4="mrs.","female","")

vishal vodro.

Thanks Vishal

Good to see this post still alive even after 4 years... Cheers...