Formula to Search for the Latest update Criteria Name

[Lukma]

Hi Friends

I need a some assistance with a formula on my data

i have list of name in Column C3 to C5 i need my formula D3 & E3 to find the latest update information about the Name from Column D9 and E9

Example Allianze Jade the it should give me the latest information about allianze Jade in D & E

Appreciate your help with the formula

H&G - Summary Tracking - 2022.xlsx
	B	C	D	E
2	Vessel	Total on-Hire Days	Total Numbers Off-hire Days	Vessel Status Notification
3	Allianz Jade		Demobilization	Chargeable
4	Barge Safeen
5	LCT-Pioneer Eagle
6
7	February-2022
8	Month	Vessel	Onhire/Offhire	Category
9	January	Barge Safeen	Mobilization	Chargeable
10	January	Allianz Jade	Demobilization	Maintenance Days
11	January	LCT-Pioneer Eagle	Demobilization	Chargeable
12	January	Allianz Jade	Mobilization	Chargeable
13		Barge Safeen	Demobilization	Chargeable
14
15
16
Data_Entry

Cell Formulas
Range	Formula
B9:B16	B9	=IFERROR(EOMONTH([@[Start Datetime]],-1)+1,"")

Cells with Data Validation
Cell	Allow	Criteria
C9:E16	Custom	=COUNTIFS($E$9:$E$16,$E9,$D$9:$D$16,$D9,$C$9:$C$16,$C9)<=1
B7	List	=Info!$I$2:$I$13

 

[Legacy 143009]

There are two records for Allianz Jade:
Demobilization Maintenance Days
Mobilization Chargeable

How did you come up with the result:
Demobilization Chargeable

 

[jasonb75]

edit:-

Removed answer, I missed the anomaly that @Flashbond has pointed out in the previous post.

 

[Lukma]

There are two records for Allianz Jade:
Demobilization Maintenance Days
Mobilization Chargeable

How did you come up with the result:
Demobilization Chargeable

Good Mornin flashbond,

thanks i simply give an example to what i was looking for and you are right

the column B i place the name fix there so in my data i gave an example Barge Safeen with the current status mobilization and Chargeable

So i need a formula that provides me with the current status of the vessel as a reminder to avoid duplicate entry because data will be shared to many

Appreciate your assistance

H&G - Summary Tracking - 2022.xlsx
	B	C	D	E	F	G	H	I	J
2	Vessel	Total on-Hire Days	Total Numbers Off-hire Days	Vessel Status Notification
3	Allianz Jade
4	Barge Safeen		Mobilization	Chargeable
5	LCT-Pioneer Eagle
6
7	February-2022
8	Month	Vessel	Onhire/Offhire	Category	Start Datetime	End DateTime	Days	Customer	Remarks
9	January	Barge Safeen	Demobilization	No Charge	01/01/2022 1:10	02/01/2022 2:00	-1
10	January	Barge Safeen	Off-Hire (Short Term)	Maintenance Days	02/01/2022 3:00	04/02/2022 15:00
11	January	Allianz Jade	On-Hire	Demobilization	01/01/2022 1:10	02/01/2022 2:00	1
12	January	LCT-Pioneer Eagle	Mobilization	Technical Planned Maintenance	02/01/2022 3:00	04/02/2022 15:00	33
13	January	Barge Safeen	Mobilization	Chargeable	02/01/2022 3:00	04/02/2022 15:00	33
Data_Entry

Cell Formulas
Range	Formula
B9:B13	B9	=EOMONTH(F9,0)-1
H9:H13	H9	=IF(D9="Mobilization",DAYS(G9,F9),IF(D9="On-Hire",DAYS(G9,F9),IF(D9="Demobilization",DAYS(F9,G9),IF(D9="Off-Hire(Short term)",DAYS(F9,G9),IF(D9="Off-Hire (long Term)",DAYS(F9,G9),IF(D9="Non-Contractual Period",DAYS(F9,G9),""))))))

Cells with Data Validation
Cell	Allow	Criteria
C9:C13	List	=Info!$G$2:$G$4
D9:D13	List	=Info!$D$2:$D$7
E9:E13	List	=Info!$H$2:$H$12
B7	List	=Info!$I$2:$I$13

 

[Legacy 143009]

For D3:

=LOOKUP(2,1/($C$9:$C$13=$B3),D$9:D$13)

 

[Lukma]

For D3:

=LOOKUP(2,1/($C$9:$C$13=$B3),D$9:D$13)

Hi Flashbond

Many Thanks

 

[Legacy 143009]

Glad it did help