First, you'd need to automate Excel & open the workbook, as described in this thread: https://www.msofficeforums.com/word-vba/16330-how-import-list-excel-into-drop-down.html#post46287 (to which I've previously referred you). Having done that, you'd employ Excel's 'WorkSheetFunction' method to do the match or lookup.

PS: I've merged your two threads as they're dealing with essentially the same issue. And, given the code I've previously directed you to, I can't see why you'd need any of these functions.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]