Show cell from another table by “identifying” a row

Hello,

Thanks for this awesome plugin.

Here is my question.
I frequently need to use data from tables in other tables.

As of now, I’m using the single cell shortcode, but I feel like that’s not ideal. I’d rather be able to say “show me the cell in column 1 of the row where “X” appears in table “Y””, than having to state exactly which row or cell I’m using.

Let’s say I have a table like this :

table X
a | b | identifierword

I’d like to be able to do something like this in another table :

table Y
c | d | [table-cell = column1 of where identifierword appears]

which would display :
c | d | a

I’m sorry if this has been asked or answered already or if I’m missing something simple, I haven’t managed to find something about it. Thanks a lot.