Forum Discussion
Solved
IF/OR INDEX MATCH STATEMENT
Please, Please Help. I have my last major hurdle to fix on a complicated project I have been trying to get done for way too long between busy times. I am using Windows 10 Enterprise with Excel 365 ...
=IFERROR( INDEX('ITL_Bulk Varieties'!$AK$2:$AK$8, MATCH($C$6,'ITL_Bulk Varieties'!$E$2:$E$8,0)),"") &IFERROR( INDEX('DOMESTIC VARIETIES'!$AK$2:$AK$32, MATCH($C$6,'DOMESTIC VARIETIES'!$E$2:$E$8,0)),"")
In your formula
=IF(
OR( $E$3={"CAN.INTL","BULK"} ),
IFERROR( OFFSET( 'ITL_Bulk Varieties'!$A$1,
MATCH( 1, INDEX( ($E$3='ITL_Bulk Varieties'!$A$2:$A$652 )*
($C$6='ITL_Bulk Varieties'!$E$2:$E$652),,),
0 ),
MATCH( $S$9, 'ITL_Bulk Varieties'!$A$1:$CC$1,0) -1,
1,1),
100 - R10 - R11 - R12),
IFERROR( OFFSET( 'DOMESTIC VARIETIES'!$A$1,
MATCH( 1, INDEX( ($E$3='DOMESTIC VARIETIES'!$A$2:$A$600)*
($C$6='DOMESTIC VARIETIES'!$E$2:$E$600),,),
0 ),
MATCH( $S$9, 'DOMESTIC VARIETIES'!$A$1:$CP$1, 0) - 1,
1,1),
100 - R10 - R11 - R12)
)MATCH() in first portion finds something, thus OFFSET() returns value, thus "red" portion is not triggered by IFERROR()