Need to plot the next lower level number `Set Text'.

Hello

In the light yellow cells by formula need to plot the next immediate lower level number `Set Text'.

thanks in advance

This works on your example data

=INDEX(C$1:C3,MAX(IF((A3-1=A$2:A3)*(LEN(A$2:A3)>0),ROW(A$2:A3))),1)

Depends what the rest of your data looks like, but this works.

Hello

Thanks for the formula, But the formula shows error and i have attached the attachment.

You've entered the formula in D2, but that row doesnt need a formula since subtracting 1 from A2 (which is 0) will result in -1 and there is no -1 to find in column A.

Perhaps I should have said what cell to enter it in.
Enter the formula in D3

=INDEX(C$1:C3,MAX(IF((A3-1=A$2:A3)*(LEN(A$2:A3)>0),ROW(A$2:A3))),1)
Also this is an array formula
Array formula, use Ctrl-Shift-Enter

and copy down the column.

d2=IFERROR(LOOKUP(A2-1,A$1:A1,C$1:C1),"")
Try this and copy towards down

Hello

Special-K and Samba Thanks to both of you

Both of your formulas working well, thank you again.