Looking from the newest price in another table

[AwalePaca]

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)"  😉

How should I enter the correct syntax ?

Thanks

[Marc_Dillon]

LOOKUP( MAXROW() )

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