Formula for value from last row

[Nicolas_Feldman]

Hi everyone.

Im working on a concatenate formula for a HYPERLINK.

The formula works fine as shown, when [Total] is in the same table and row: CONCATENATE(https://paypal.me/kaanexpeditions.com/, [Total], mxn)

Now im trying to obtain the [TOTAL] value from the last row of a different table “Ventas”.

Any ideas?
I tried LOOKUP and MAXROW, but I believe this wont work as MAXROW only brings back Key Columns and not the desired column [total].

concatenate(“https://paypal.me/kaanexpeditions/”, MAXROW(VENTAS2, TOTAL), mxn)

Thanks!