Help with formula with more conditions
Could someone help me solve the problem?
I have two sheets in one I have information like the first and last
name.In the second sheet I have some data checking of sex and certain
words related to sex. is there a possibility, with the help of a
formula, to see if there is a male or a female and whether
he is driving a driver A or B and that he connects certain cells
into a sentence that would be related to that man or woman
(as I put it in sheet 1 - example)?
I put the table in the attachment.
I made a mistake in book1 (attached file)example should be in f2 cell in sheet 1
Thanks in andvanced
Aleksandar
|