Snasui Excel Forum

norkaz wrote: Fri Jul 16, 2021 10:09 am ...


B2

=IFERROR(INDEX(Sheet1!A:A,AGGREGATE(15,6,ROW($A$2:$A$15)/(MATCH(SUBSTITUTE(Sheet1!$A$2:$A$15,"*","#"),SUBSTITUTE(Sheet1!$A$2:$A$15,"*","#"),0)=ROW($A$1:$A$15)),ROW(A1))),"")

Copy ลงไป

Norkaz

Bo_ry wrote: Mon Jul 05, 2021 10:14 pm B2
=VLOOKUP(SUBSTITUTE(A1,"*","~*"),Sheet2!A:B,2,FALSE)