CyrusTheVirus
Well-known Member
- Joined
- Jan 28, 2015
- Messages
- 749
- Office Version
- 365
- Platform
- Windows
Hi everyone,
I'm looking for a different way of writing the below formula. The only way I could make it work was by combining it into an IF function...
Basically, I'm trying to make the index/match populate a value ONLY if it meets one of two criteria... the criteria being in cells D1 ("def") and E1 ("ghi")
Entered with or without(?) CSE in cell E4, then copied down to E8...
<tbody>
</tbody>
Also curious exactly why the formula works with or without using CSE...?
I'm looking for a different way of writing the below formula. The only way I could make it work was by combining it into an IF function...
Basically, I'm trying to make the index/match populate a value ONLY if it meets one of two criteria... the criteria being in cells D1 ("def") and E1 ("ghi")
Entered with or without(?) CSE in cell E4, then copied down to E8...
Code:
=IFERROR(IF(OR(INDEX($B$4:$B$7,MATCH(D4,$A$4:$A$7,0))=$D$1:$E$1),INDEX($B$4:$B$7,MATCH(D4,$A$4:$A$7,0)),""),"")
A | B | C | D | E | |
1 | def | ghi | |||
2 | |||||
3 | |||||
4 | corey | abc | corey | blank = formula | |
5 | derek | def | adam | ghi = formula | |
6 | adam | ghi | chris | blank = formula | |
7 | josh | jkl | josh | blank = formula | |
8 | derek | def = formula |
<tbody>
</tbody>
Also curious exactly why the formula works with or without using CSE...?