Formula to find value in range

[gtd526]

Hello,
Im looking for a formula to find a cell value in a range of cells.
=IF(AND($A4=1,$B4=1,$E4=$X16),$D4,"")

I would like to use a Range in A,B,E & D to find a given value.
$A$4:$A$21=1 , criteria1
$B$4:$B$21=1 , criteria2
$E$4:$E$21=$X16 , criteria3
$D$4:$D$21 , if True

If the 3 criteria is True, then bring Value of D:D
$X16 will change correctly as I fill down.

The value Im looking for could be in any cell within the Range.

Thank you.

 

[gtd526]

Hello,
Im looking for a formula to find a cell value in a range of cells.
=IF(AND($A4=1,$B4=1,$E4=$X16),$D4,"")

I would like to use a Range in A,B,E & D to find a given value.
$A$4:$A$21=1 , criteria1
$B$4:$B$21=1 , criteria2
$E$4:$E$21=$X16 , criteria3
$D$4:$D$21 , if True

If the 3 criteria is True, then bring Value of D:D
$X16 will change correctly as I fill down.

The value Im looking for could be in any cell within the Range.

Thank you.

Nevermind. I solved it with what I wrote in the message.