LOOKUP Function in normal columns

[Soufiane_M]

LOOKUP function works good with virual columns but in normal columns (I mean columns of the spreadsheet) does not work ; why ?? is there an alternative solution that can do the same work ??*

My formula that am working on : LOOKUP([_thisrow].[ID_article],“op_vente”,“article_id”,“id_op_vente”)