gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 660
- Office Version
- 2019
- Platform
- Windows
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.
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.