IF with COUNTIF function

[Ramadan]

I'm trying to use this function =IF(COUNTIF(sheet2!B:B,D7)&(sheet2!C:C,C7),sheet2!B2,"") to check IF (D7 in this sheet = any cell value in sheet2 in column B:B) and IF (C7 in this sheet = any cell value in sheet2 in column C:C) if ok so to return with "B2" value otherwise to keep the cell blank but i get #VALUE error
IF D7 = sheet2!B:B
AND IF C7 = sheet2!C:C
make the cell = B2 in sheet2, if NOT keep it blank

How to retype it in the correct way?

 

[Ramadan]

now I reached something good but still not working. I edited the formula to be like this =IF(COUNTIF(Sheet2!B:B,D7)>0,IF(COUNTIF(Sheet2!C:C,C7)>0,Sheet2!B2,""))

but while everything is matching true i get blank cell

 

[Special-K99]

Try
=IF(COUNTIF(Sheet2!B:B,D7)*COUNTIF(Sheet2!C:C,C7),Sheet2!B2,"")

 

[Kerryx]

=IF(AND(COUNTIF(District1!B:B,D7)>0,COUNTIF(District1!C:C,C7)>0),District!B2,"")

 

[Special-K99]

now I reached something good but still not working. I edited the formula to be like this =IF(COUNTIF(Sheet2!B:B,D7)>0,IF(COUNTIF(Sheet2!C:C,C7)>0,Sheet2!B2,""))

but while everything is matching true i get blank cell

Your formula works for me.
It will be interestuing to see what Kerryx's formula produces.
If that doesn't produce the correct results it would point to a data problem.

My first thought would be spaces in the cells after the data.