Search results

Brilliant, works perfectly, thanks Narayan!

I am stuck trying to solve this question after searching for hours and trying different code. Using a data validation dependent list, is it possible to use code to set a default to display when the list is "activated", any time through all ranges on the sheet? Example: Worksheet with B4...

OK, I put this in: {=IF(MAX(($A$4:$A$55=$A64)*(B$4:B$55<>"OFF"))>0,"Yes",IF(MAX(--($A$4:$A$55=$A64)),"NO","Yes"))} Unfortunately getting the same result; returns "YES" when the search criteria 1 is NOT present in the range A4:A55 BUT! I altered it to this, and it seems to be...

The logic is correct. I used the provided formula {=IF(MAX(($A$4:$A$55=$A64)*(B$4:B$55="OFF")),"NO","YES")} - all works, EXCEPT if "L Saute" is not in A4:A55, it is still returning a "YES". It's so close, just not all the way there yet. Thanks, let me know if there is a tweak needed.

Thanks for the welcome and reply Hui. Sample workbook is here: https://www.box.com/s/jl5k2zunxs1sm610prtz "Data" is the sheet to look at, and I know the sheet is not a typical format. The current formulas in A64:A83 can be ignored, they are from another workbook. A63:A83 would be the...

Greetings- Having trouble creating a formula that checks for 2 distinct criteria in a range within 2 different columns to determine if they are true or false (each criteria is in a range in different columns). I hope someone here can help. It needs to function like this: If criteria 1 is...