Last record from another table in virtual column

[Apper]

Hi Guys!
After reading a lot and trying different expressions I’ve got stuck!

Would someone be able to help me out with next problem?

I have Table_1 where I’d like to create virtual column, which would return the last value of the Column 3 from Table_2 if the Column_1 from Table_1 is matching Column_1 from Table_2. Also I cannot make the Column_1 in Table_2 the key value as it repeats its value throughout the table many times, so I have to use there UNIQUEID() key.

Many thanks!

[Lynn · Accepted solution]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW() MINROW() REF_ROWS() SELECT() What is a Key? Adding & updating rows Is this a new row?/Does this row already exist? What is the previous value of this column? Excel alternatives How do I do COUNTIF() or COUNTIFS()? How do I do SUMIF() or SUMIFS()? How do I do VLOOKUP()? Last row of the spreadsheet How do I get the last row of the spreadsheet? How do I get a column value from…

[Apper]

Last link helped solved my problem.

Thank you so much!