Finding two values

[David030965]

Hello,
Sorry in advance if this has already been asked. I produce reports monthly detailing training for my hospital . I want to be able to find two specific names in a range and then then return specific text in another cell ("Not Required"). However I already have a complex formula running to find training information. If I am able to find a formula how do I then embed (or nest I guess) within the existing formula.
thank you in anticipation

 

[Aladin Akyurek]

Try to provide a small sample along with the desired result. Also, what is the formula you want to expand with the solution?

 

[David030965]

Hello,
Sorry in advance if this has already been asked. I produce reports monthly detailing training for my hospital . I want to be able to find two specific names in a range and then then return specific text in another cell ("Not Required"). However I already have a complex formula running to find training information. If I am able to find a formula how do I then embed (or nest I guess) within the existing formula.
thank you in anticipation

Here is the formula I want to embed any answer into
=IF(AND(VLOOKUP($E5,Bandings!$A:$B,2,FALSE)<5,G$1=1),"Not Required",IF(COUNTIFS('Staff with Competencies'!$D:$D,'Barclay Thoracic'!$D5,'Staff with Competencies'!$F:$F,G$4)=0,0,IF(COUNTIFS('Staff with Competencies'!$D:$D,'Barclay Thoracic'!$D5,'Staff with Competencies'!$F:$F,G$4,'Staff with Competencies'!$J:$J,"Yes")=1,1.01,1)))
thank you

 

[Aladin Akyurek]

What dd you want to "embed" in this fomula?

 

[David030965]

Hi
On another sheet I want to find two surnames (selby & Bell) and so they are "Not Required" to use specific devices