It looks like the arguments of your match function are wrong. Generally, the
second argument (where you have J38) would be a range of cells where the
match function should look; otherwise, you could just use IF (as in if
j36=j38). Next, if you want an exact match, you should provide the match
function with a third argument, FALSE.
If the function originally was returning NA and you dropped that same
function inside the isna test, the result should be blank.
--Bruce

"Ltat42a" wrote:


bpeltzer Wrote:
You can test the result of the match function with the isna function.
Instead of =match(...), try =if(isna(match(...)),"","MATCH")
--Bruce



Thanx Bruce, I tired that, my formula -
=IF(ISNA(MATCH(J36,J38)),"","MATCH")
When I put in the same number in J36 as J38, I do get the "Match"
results, however, if I put in a different number in J36, the result
still says "Match" no matter what number I put in J36.

J36 is the cell that changes frequently; J38 remains constant.


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=515052