Lookup formula

[geo Jul]

Dear All,
please I need to pull data from column C according to column G expected result in Column F
Your suggestion and help is highly appreciated
Many thanks

 

[vletm]

Something like this?
Formula in cell H3
with K-column

 

[geo Jul]

Something like this?
Formula in cell H3
with K-column

I’m grateful for the support you’ve provided and Your help has made a significant impact

 

[geo Jul]

Something like this?
Formula in cell H3
with K-column

I amend your formula to read like this many thanks again for your help. SORTBY(C3:D35,MATCH(D3:D35,UNIQUE(SWITCH(SORT(SWITCH(D3:D35,"successful",1,"medium",2,"Failure",3,"absent",4,""),1,1),1,"successful",2,"medium",3,"Failure",4,"absent","")),))

 

[vletm]

geo Jul​

Someone would use this:
=SORTBY(C3:D35,MATCH(D3:D35,{"successful","medium","Failure","absent"},))