Title Validation

[ashok0141]

Hi There,

Request to validate correct title keyed with name or not.

i have attached a excel where valid title list is given.

need to automate the validation process where if name is with keyed with title then check if valid title keyed or not.

if name is without title then produce output as valid

please let me know if there is any question on the above case

Regards,
Ashok

[mehmetcik]

Formula for C3

Please Login or Register  to view this content.

[ashok0141]

thanks for the formula, but it is not solving my purpose completely.

i would request you to please refer the attached sheet, i have mentioned the valid and invalid title list.

in the start if customer name contains the title from the list mentioned then produce respective result

and if nothing found from the list then produce result "valid"

Regards,
Ashok

[Leith Ross]

Hello ashok0141,

This formula worked for me...

=IF(ISBLANK(B3),"",IFERROR(VLOOKUP(LEFT(B3,SEARCH(" ",B3)-1),$J$3:$K$16,2,FALSE),"Invalid"))

[ashok0141]

just need to modify the formula if name is keyed without any tittle from the range J3:J16 then it should produce "valid"


if we use the same formula for names mentioned in B12 and B14, it produces "invalid" but it should produce "valid".

Regards,
Ashok