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.