I need to check in excel whether a column (b1:b300) contains only 2 specific values 1,-24. How can check this using formulas only. Please help
You can use a VLOOKUP, and depending if you search for ANY of the two or BOTH of the two, you combine two VLOOKUP as needed.
=VLOOKUP(arg,range,1,FALSE)
will yield #N/A
if not found, which can be further analyzed using the =ISNA()
function
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With