Same as cached_lookup, but returns the full result
Source: R/utils_lookup_cache.R
cached_lookup_result.RdCallers that need to tell a confirmed "absent" apart from an inconclusive
"failed" lookup (see resolve_external_field) need the status,
not just the value cached_lookup returns.