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 ...

11TH BAGGING NEW UPDATE 11.3.21 sample.xlsx420 KB

excel

Formulas and Functions

Detlef_Lewin

Nov 03, 2021

kdwork

=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)),"")

=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)),"")

Forum Discussion

IF/OR INDEX MATCH STATEMENT

Resources