Querying cells conditionally in Google Sheets

Calling a cell or cells in another Spreadsheet:

Calling a cell or sells in same Spreadsheet using a named range or worksheet name: