Edit match formula

Hi

I have a formula that is working great for the task in hand that would give a value if 2 criteria was matched.

=IF(AND(N3<=3,Q3=$Q$4),5,"")
------------------------------------------------------

What i now require is Q3 to match or be in range by 3 more of Q4 (but no less than Q4)

Q3=$Q$4)

Hope i have explained myself well enough

Thanks for looking

msexcelathome

Unfortunately that formula gives a #value! error when cells are blank, if it can be modified to not recieve error please

Hi I thought i better attach a sheet with the macro running, it will give you a better idea of what i mean.

Thanks

bebo

just tested on attachment and seemed to do the trick i will try it on my work this evening and get back with what i get there .

Thanks Pal

Just tried it on work and it seems that it is only taking the number into account but ignoring the text, for example: if number/text to match is 19Hy in cell A1, In C2 it matches 19Hy,20Hy,21Hy,22Hy which is great but it will also match 19Hd 19Fg 20Gh 22Zj and so on, so in other words the text must be an exact match but the number to be in range of number, another example: if (A1) states 45Gs the only possible matches in (C2) are (45Gs,46Gs,47Gs,48Gs)=true. (45St,46St,47St,48st)=false.

Almost there so close

bebo

You are a master, i bow to you again and again, that is some monster text which is going in my note pad for later use

I need to bog your brains again using same formula instead of making new thread if thats ok? ill explain also have added the same sheet as example.
I require 3 other criteria included in your formula ---------> (Match Cell) (Match Cell) (Less Than Cell)by having these 5 criteria it would pin point a near enough fact to pay more attention to.

your formula is in the sheet already just needs edit.

Thanks again bebo for your time i really do appreciate it you Star Seed.

I added more info on sheet hope its better

Thats fantastic bebo it works exactly as it should +++++++

Thank alot for all your help

I am going to start a new thread as i have 300 rows of this code to add and when i copy as format it does not paste part of the code to reflect the row it is in.

(EXACT($E$1,$E$2),EXACT($F$1,$F$2),$G$2<$G$1,EXACT cells do not change when copy/paste whole column.