Value error in IF formula?

gony28

New Member
Joined
Apr 26, 2019
Messages
2
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
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,430
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Apr 26, 2019
Messages
2
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,108,527
Messages
5,523,393
Members
409,515
Latest member
chemitek

This Week's Hot Topics

Top