c1=if(iserror(match(b1,$a$1:$a$100,0),"",index($a$1:$a$100,,match(b1,$a$1:$a$100,0)+1,1))
请问是C1等匹配数值的下个单元格,这个数值是指A列的数值,还是指B列的数值?
=if(a1=b1,a2,"")