Try:
=IFERROR(INDEX($A$1:$E$1,,LOOKUP("completed",OFFSET($A$1:$E$1,MATCH(J2,$A$2:$A$4,0),),{1,2,3,4})),"")
Try:
=IFERROR(INDEX($A$1:$E$1,,LOOKUP("completed",OFFSET($A$1:$E$1,MATCH(J2,$A$2:$A$4,0),),{1,2,3,4})),"")
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks