Are you asking how to make the formula disregard the case of the text when it
compares?


"F. Lawrence Kulchar" wrote:

How can I test a text value in a cell when CAPITALIZATION DOES NOT EQUAL
LOWER CASE???

In other words, "MIAMI" and "Miami" is NOT a match.

Thanks,

FLKulchar