lookup value base on condition from another columns in the same list

Occasional Visitor


I'm new at SharePoint List and I've an List that collect daily production data base on counter from machin.

My columns in the list is [COUNTER],[MACHIN],[MOLD_NUM],[WORK_ORDER].

I want to add an column that in the row will lookup the [COUNTER] for the same [MACHIN],[MOLD_NUM],[WORK_ORDER] from the last time I've dot the data to the new column, if there is no data in the new column will be 0.

Can I do it?

0 Replies