Jan 17th 2021 #1 Could any one please help to create formula for attached file data. A VBA code also helpfull.Thank YouAnsh
Jan 17th 2021 #3 Or try this non-array formulaIn A1, formula copied down :=IFERROR(LOOKUP(1,SEARCH(L$1:L$4,B1),M$1:M$4),"")Regards