To Pull a recent status from another sheet
Hope you are doing well.
I have one sheet "Sheet 1", in which we have 2 fields that will be filled through the form. One for scanning the barcode of the Product and 1 for updating the status of the Product Process for ex- Raw material at the warehouse, Raw material in the manufacturing process, etc.
In the 2nd Sheet, I want to show the recent Status of the Product from sheet 1.
If in sheet 1, there are 6 status and each status is changing at different points as the process goes on.
So I want to show the recent status on sheet 2 and I am thinking to fetch the status through vlookup.
Please provide an effective solution so I implement it on my project.