Excel Help states that EXACT compares two text strings, not one with a
series of strings. Use 5 formulas or VLOOKUP combined with EXACT.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Muks" wrote in message
...
I am using EXACT to compare a cell value with series e.g. =EXACT(B2,A1:A5).
It gives me TRUE only when B2=A2 and FALSE even though B2=A4.
What may be the issue? Pls suggest.
Thanks in advance.
Muks
|