Value error in IF formula?

[gony28]

I require some help with the highlighted part of the formula as shown in the link below. I need it to return the value in J2 if the two criterias given matches. if not, contunie with the rest of the fomula. I keep getting a #value error. The criteria 1 is for the date in B2 to exist in the range B14:B25 and criteria 2 is for F2 to = 6. IF the criterias are fullfilled i need it to return the value in J2. What am I doing wrong here?

https://drive.google.com/open?id=13vUCqzxdI45ywHanwezz0xDj4y3euWPJ

 

[FormR]

Hi, welcome to the forum!

You can't check if a value is in a range like that, but you could use something like this instead..

=IF(AND(ISNUMBER(MATCH(B2,B14:B25,0)),F2=6),.....etc.

 

[gony28]

hi, welcome to the forum!

You can't check if a value is in a range like that, but you could use something like this instead..

=if(and(isnumber(match(b2,b14:b25,0)),f2=6),.....etc.

thank you so much!!! It really worked!