REQUIRED STATUS

[Basavaraj K H]

Hi Chandu,

Kindly find the attachment, in that i mentioned the required status in third sheet, in that condition should be come in second page, kindly help me.

 

[John Jairo V]

Hi @Basavaraj K H

An option could be (In K2):
=INDEX(G$1:J$1,MATCH(1,G2:J2,)) <-- Copy it down.

Blessings!