I am running a report on Excel 2019 which has 2 sheets, and I want to automate the value in the field called Status in the sheet2 with the new status on sheet1 where a new row was added for the same item.
Ex:
thank you.
I tried index match, but a random update pull the data and new row is added down below and I lost my references. The Max function is good as well considering the last date of status was pulled, but I need to select the whole column and the max function just bring me the same last date for everyone.
I want to get from sheet1 the last status for the same login updated in a new row added and take to sheet 2.
Lookup Last Occurrences Using
LOOKUP
If
Status
is inSheet1!A1
andSTATUS
is inSheet2!B1
then inSheet2!B2
use the following formula:and copy down.