Jan 28 2019 07:20 PM
I'm trying to write a formula that will prompt review based on certain criteria in a list. The only "true" return values I'm getting are on the argument with a greater than numberic value. Is there another/better way when 2 of the arguments are text values?
=IFERROR(IF(OR(A246=Rules!B:B,Q246=Rules!A:A,N246<35),"","Review"),"Review")
Jan 28 2019 08:21 PM
Hi @Kristy_Jane
Could you post a sample file to show what you are trying to do ?
I'm a bit confused by the A246=Rules!B:B,Q246=Rules!A:A part
Thanks
Wyn
Jan 28 2019 09:10 PM
I'll try to get a sample file uploaded. Rules!A;A and Rules!B:B is referencing a range on another worksheet, same workbook. So if Q2 equals any value in the range in Column B on Rules tab, value should return "".
Jan 28 2019 11:50 PM
SolutionJan 29 2019 03:37 PM
This worked perfectly! I tried similar, but I must have been missing a piece of the argument. thanks! @Wyn Hopkins
Jan 28 2019 11:50 PM
Solution