D
Dries
Hi Experts,
I have the following problem which I need to solve and have no idea on which
functions I can use:
In sheet one I would like to get a name of a person which has 2 conditions
in sheet two:
Structure of Sheet 2
Name - adress - Condition 1 - tel - condition 2
A - none - A - OK - E
B - None - D - OK - E
C - OK - A OK - C
D - false - D - OK - G
E - n/a - A - OK - E
In the First sheet I would like that in the first line the person who has as:
Condition 1 : A
Condition 2 : E
Result woult be person with name A
Than I would like to insert a line
Find next person with
Condition 1: A
condition 2: E
Result would be person with name E
Any idea if this is possible? and how?
I have the following problem which I need to solve and have no idea on which
functions I can use:
In sheet one I would like to get a name of a person which has 2 conditions
in sheet two:
Structure of Sheet 2
Name - adress - Condition 1 - tel - condition 2
A - none - A - OK - E
B - None - D - OK - E
C - OK - A OK - C
D - false - D - OK - G
E - n/a - A - OK - E
In the First sheet I would like that in the first line the person who has as:
Condition 1 : A
Condition 2 : E
Result woult be person with name A
Than I would like to insert a line
Find next person with
Condition 1: A
condition 2: E
Result would be person with name E
Any idea if this is possible? and how?