Adding another if
=IF(LEN(B4)>0,IF(MID(B4,1,1)=MID(B4,3,1), 1,INDEX($D$2:$H$2, MATCH("?"&MID(B4,2,1)&"?"&MID(B4,4,1),$D$1:$H$1,0)),"")
Adding another if
=IF(LEN(B4)>0,IF(MID(B4,1,1)=MID(B4,3,1), 1,INDEX($D$2:$H$2, MATCH("?"&MID(B4,2,1)&"?"&MID(B4,4,1),$D$1:$H$1,0)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks