In Need of Formulas for my Document Register. Please help.

In D4 copied across and down:

=IFNA(LOOKUP(2,1/(($H$3:$V$3=D$3)*($H4:$V4<>"")),$H4:$V4),"")

Thank you, thank you so much for the help! May you received more blessings and more power to you!

You're welcome.

Miss Ali I do have a follow-up question regarding the the whole formula on the top that you've used, could you please explain part by part? Actually I already applied it on my actual register and perfectly doing the job but I want to fully understand how it works. Thanks you again and sorry for the private mail.

This bit:

($H$3:$V$3=D$3)*($H4:$V4<>"")

produces a matrix of TRUE and FALSE which then, when multiplied together, produces 1s and 0s.

2,1/

This ensures that only the LAST instance of 1 is returned, e.g.

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
22	08/02/2024	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE
23		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE
24		0	0	0	1	0	0	0	0	1	0	0	0	0	0	0

Sheet: Sheet1

Thank you very much again Miss Ali for the knowledge.

You're welcome.

Dear Sirs,

Just bear in mind that we are not all men here ...