If with Index Match

[AgingRapidly]

Greetings,
I'm trying to tell Excel365 that IF cell is blank in InvOnlyItems, to bring in the item description from InvOnlyItems after matching the item codes in 2022 QC Production Testing Report and InvOnlyItems, otherwise, bring in the extended item description from InvOnlyItems after matching the item codes in 2022 QC Production Testing Report and InvOnlyItems. I'm stumped.

I also need to know best way to reference InvOnlyItems that is saved in a network folder.

Thank you in advance for your assistance.

InvOnlyItems.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	ItemCode	ItemCodeDesc	ExDescKey	ProductLine	ProductType	CasePack	Volume	InactiveItem	ProductLine_w_Desc	CI_ExDescriptionNo	CI_ExDescriptionText
2	00405	10oz PROTEIN GEL REGULAR 12pk	0	0110	F	12	10	N	0110-PROTEIN GEL	0
3	00415	15oz PROTEIN GEL REGULAR 12pk	0	0110	F	12	15	N	0110-PROTEIN GEL	0
InvOnly_W_ProdLine_ExDesc

2022 QC Production Testing Report.xlsx
	D	E
4	54700	#SPILL!
5	40622	#SPILL!
6	41072	#SPILL!
2022

Cell Formulas
Range	Formula
E4:E6	E4	=IF('P:\Sage\Sage Data Files\InvOnlyItems.xlsx'!F_ExDescKey="0", INDEX('P:\Sage\Sage Data Files\InvOnlyItems.xlsx'!F_ItemCodeDesc,MATCH(UE_Item_No,'P:\Sage\Sage Data Files\InvOnlyItems.xlsx'!F_ItemCode,0)), INDEX('P:\Sage\Sage Data Files\InvOnlyItems.xlsx'!F_CI_ExDesc_Text,MATCH(UE_Item_No,'P:\Sage\Sage Data Files\InvOnlyItems.xlsx'!F_ItemCode,0)))

Named Ranges
Name	Refers To	Cells
UE_Item_No	='2022'!$D$4	E4:E6

 

[AgingRapidly]

Looks like I may have created a mini tab from the wrong file. This should be InvOnlyItems.

InvOnlyItems.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	ItemCode	ItemCodeDesc	ExDescKey	ProductLine	ProductType	CasePack	Volume	InactiveItem	ProductLine_w_Desc	CI_ExDescriptionNo	CI_ExDescriptionText
2	00405	10oz PROTEIN GEL REGULAR 12pk	0	0110	F	12	10	N	0110-PROTEIN GEL	0
3	00415	15oz PROTEIN GEL REGULAR 12pk	0	0110	F	12	15	N	0110-PROTEIN GEL	0
InvOnly_W_ProdLine_ExDesc