Hi
I have had great help on my project with formulas of which i am making varients of some formulas given for different criteria. I am having trouble with part of a match formula which i want to change slightly: =IF(AND(EXACT($O3,$X3) is the part i wish to change so that Cell O3 can be in range by 2 less and still be a match i.e O3=4 & X3=4 is a match but also O3=2 & X3=4 is a match But O3=5 & X3=4 is NOT match
Here is the full formula so you know not to effect anything else:
=IF(AND(EXACT($O3,$X3),EXACT(TRIM(SUBSTITUTE(K3,MAX(IFERROR(--MID(K3,1,ROW(INDIRECT("1:"&LEN(K3)))),"")),"")),TRIM(SUBSTITUTE(V3,MAX(IFERROR(--MID(V3,1,ROW(INDIRECT("1:"&LEN(V3)))),"")),"")))),IF(AND(N3<=3,ISNUMBER(MATCH(TRUE,MAX(IFERROR(--MID(K3,1,ROW(INDIRECT("1:"&LEN(K3)))),""))=MAX(IFERROR(--MID(V3,1,ROW(INDIRECT("1:"&LEN(V3)))),""))+{0,1,2,3},0))),5,""),"")
Thanks
Bookmarks