Simplified Formula (EXCEL 2003)

Topic

New Reply

For the attached spreadsheet, is there a way to simplify the formula in C2:C5?
i.e. remove the ISNUMBER function.

Reply | Quote

Replies

You could use

=IF(COUNTIF($A$2:$A$10,B2),"True","Error")

or even

=COUNTIF($A$2:$A$10,B2)

In the latter case, format the cells with the custom format

"True";;"Error"

Reply | Quote

Not shorter than Hans’ but without the isnumber

=IF(ISNA((VLOOKUP(B2,$A$2:$A$8,1,FALSE))), “Error”,”True”)

Reply | Quote

Thank You!

Reply | Quote