Excel: Index Match with partial text search into another Worksheet

Question

Attempting to use a Index* + Match* + Match partial* function from one Workbook to another Workbook.

This formula works within the same workbook, but fails once applied over to another Workbook.

• Retrieving Workbook: Ship Log
• Retrieving Sheet: 2023
• Index search column: F:F
• First Match column: H:H -- matching with cell: W2
• Partial Match column: I:I -- matching with cell: X2

My current formula:

=INDEX('[Ship Log.xlsx]2023'!$F:$F,MATCH(1,(W12='[Ship Log.xlsx]2023'!$H:$H)*("*"&X12&"*"='[Ship Log.xlsx]2023'!$I:$I),0))

I like to believe I'm just using the function or some component the wrong way.