Forum Discussion
Using IF command but referencing alternate rows - autofill
Hi, Please can some help me. How do I continue this sequence without having to manually adjust each equation? =IF($C6=$H$5,$D6," ") =IF($C8=$H$5,$D8," ") =IF($C10=$H$5,$D10," ") =IF($C12=...
Jan,
As third option here is slight modification of your formula to avoid using array formulas
=IFERROR(INDEX($D$5:$D$16,MATCH(1,INDEX(($G26=$B$5:$B$16)*(H$25=$C$5:$C$16),0,1),0)),"")
and attached
Wow Jan, you are amazing!
I was having problems using the array formulas but this works perfectly.
thank you so much.
James, you are welcome