BV alue exists in entire range?>: Windows 7 | Excel 2013 Hi all, I need to test

Question

BValue exists in entire range?>:

Windows 7 | Excel 2013

Hi all,

I need to test if a numerical value exists within an entire range.

This formula works if I only want to test a flat list: =NOT(ISNA(MATCH(Value,List,0))). This returns TRUE if the value exists in the List, or FALSE if it does not.

But if I substitue "list' for "range", it breaks: =NOT(ISNA(MATCH(Value,Range,0))). This returns FALSE even if the value exists in the range.

How do I duplicate the TRUE/FALSE functionality on a range with a formula? My range is 14 rows by 30 columns.

Thank you.

Explanation / Answer

^#@^&

Try this

=COUNTIF(Range,Value)>0

Hope this helps.
==

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.