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”.
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)