Home |
Search |
Today's Posts |
#1
|
|||
|
|||
EXACT formula
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
actually the help then shows an array example
{=OR(EXACT(TestValue, CompareRange))} entered without the braces and using Ctrl+Shift+Enter --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Niek Otten" wrote in message ... 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 |
#4
|
|||
|
|||
Try...
=OR(EXACT(B2,A1:A5)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "Muks" wrote: 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 |
#5
|
|||
|
|||
and of course the whole purpose of using Exact is that the
lettercase must match. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Frequency formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Use of the DSUM formula to find exact matches in datatables | Excel Worksheet Functions |