Kibana Vlookup Equivalent in Opendistro

Hi all,

I have 2 indices in an index pattern.
I want to get the documents which have the same fields values in both indices.
Basically like vlookup in excel.

I’ve tried a scripted field, but not getting approach of comparing and getting values from other document.

Apparently Enrich processor works only in Elasticsearch, but not Opendistro.

Any ideas?