Help with formula with more conditions

allex011 · #1 10-27-2018, 02:42 PM

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

ArviLaanemets · #2 10-29-2018, 03:22 AM

It is not exactly what you asked for, but I hope it is what you really need (or at least something you get a start from).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to make sum based on multiple conditions, HELP!	ilsel	Excel	3	11-15-2017 02:03 AM
Using an undefined number of conditions to give a final formula	Kopko	Excel	0	08-22-2017 01:18 PM
Sum with conditions	xling	Excel	2	08-15-2017 12:16 AM
Excel Formula for Multiple Conditions & Results	nowco	Excel	4	03-16-2016 11:24 AM
6 conditions formula	paconovellino	Excel	2	03-05-2012 06:45 AM