Virtual Column Expression

[MauriceWhelan]

I need to create a virtual column to insert an expression to pull in some values from a previous record when entering a new record. I have used MAXROW() before and it works well but I have a slightly different requirement. The expression needs to contain a condition that pulls in the data from the previous record based on previously scanned Product Code. It is something like this I need

MAXROW(“Operations_Master_Check”,"_RowNumber", (Previously Scanned Product Code)

I need this condition in because the products may not necessarily be scanned in the order that they are presented in the google sheet.

Any advice would be great.