Looking from the newest price in another table

AppSheet AppSheet Q&A
1

Hi all,
my context :

  • Table A contains :

    • ID
    • Name

  • Table B contains :

    • ID
    • Price
    • Entering date

From a name in table A, I am trying to display the Price, from the newest date.

I tried several formula :

  • =LOOKUP(MAX(FILTER(Prix, [Prix].[CodeBarre]=Jeux.[CodeBarre]), [Date de saisie]), FILTER(Prix, [Prix].[CodeBarre]=Jeux.[CodeBarre]), Prix[Prix de Vente])
  • =INDEX(Prix[Prix de Vente], MAXROW(FILTER(Prix, [Prix].[CodeBarre]=Jeux.[CodeBarre]), [Date de saisie]))

I only got error lyke

“Function ‘LOOKUP’ should have exactly four parameters: LOOKUP(lookupValue, tableName, lookupColumn, returnColumn)” :wink:
How should I enter the correct syntax ?

Thanks

2

LOOKUP( MAXROW() )

https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216

1 Like