Adding importrange to index match formula where the import range is required in both index and match

Question

I have this formula for import range that works when within the same workbook but I now need to include importrange within the ranges that sit in both index and match.

=iferror(INDEX(HS_Master!D:D,match(H2,HS_Master!C:C,)))    

The sheet reference is correct but I am not sure where the importrange & URL needs to go before index D:D and match C:C

I do not have an example sheet to share as yet but I will work on one

Any thoughts please?

Answer 1

use:

=VLOOKUP(H2, IMPORTRANGE("url", "HS_Master!C:D"), 2, 0)