Help require to create a signature

[mso3]

Hi friends,
There is a list of teachers on ‘Information’ sheet.
I want a signature on ‘Card’ sheet on the following conditions.
If the name of teacher has a title/prefix ‘Mr.’ then there will be a signature starting with ‘Sir’
Else
The signature will start with ‘Madam’

I have attached a workbook for your kind perusal.

Thanking you,

[Special-K]

=IF(LEFT(A1,3)="Mr.","Sir","Madam")

This will also turn any "Miss" into "Madam"
Are you sure that's what you want?

[LokeshKumar]

Hi,

You can create the function for the same..

Please Login or Register  to view this content.

Here is your attachment..Sign.xlsm


If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.

[mso3]

Hi Special-K,
Perfect! It's working absolutely fine as per my requirement. Thank you,

Hi LokeshKumar,
Thank you for a function. It's a nice approach.

Thank you to both of you.

[LokeshKumar]

If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.