Clear formula to track invoice status

[bradjsteve88]

I am trying to get a formula like the below that works backwards through a table, i.e. IF N6 contains date="Paid", if false check M6, IF M6 contains date = "Invoiced" and so on.

=IF(N6>0,"Paid"), IF(M6>0,"Invoiced") IF(L6>0,"Accepted") IF(I6>0,"Submitted")

 

[Peter_SSs]

If you have headings to return then try the column O formula, otherwise something like column P?

22 03 23.xlsm
	I	J	K	L	M	N	O	P
1	Submitted	Assessed	Allocated	Accepted	Invoiced	Paid
2	1/03/2022	2/03/2022	3/03/2022	13/03/2022			Accepted	Accepted
3	3/03/2022	4/03/2022	5/03/2022			8/03/2022	Paid	Paid
Status

Cell Formulas
Range	Formula
O2:O3	O2	=LOOKUP(9^9,I2:N2,I$1:N$1)
P2:P3	P2	=LOOKUP(9^9,I2:N2,{"Submitted","Assessed","Allocated","Accepted","Invoiced","Paid"})