Hi all,
I need help on this solve this problem
~PLEASE Help~The formula on Column B , Column C , Column D cannot differentiate exactly word with * and no * on the data to IFERROR & VLOOK
=IFERROR(VLOOKUP(A2,Sheet2!$A$2:$C$20,3,FALSE),"")
The formula on Column E , Column F , Column G working properly with LEN code solve by davsth. Thanks a lot.
=IFERROR(IF(MATCH(LEFT(A2,LEN(A2)-1)&"~"&RIGHT(A2,1),Sheet2!$A$2:$A$20,0),"O"),"X")
~PLEASE Help~The formula on Column H seems not to calculate very well because it calculate all when the data had * on the column A.
=COUNTIF(Sheet2!$A$2:$A$30,$A$2:$A$30)+
COUNTIF(Sheet3!$A$2:$A$30,$A$2:$A$30)+
COUNTIF(Sheet4!$A$2:$A$30,$A$2:$A$30)
Please somebody help me.
Thanks
Bookmarks