Hi - I am working on crossmatching information between two worksheets.
Does anyone know how to make the following changes to the statement
below -
1. Replace the return value = "Did not Match", to the actual
information in the contects of the cell that did not match.
2. All matched items return a result = "Match Found".
Right now, I'm getting the opposite result. Here's the formula that I
am working with -
=IF(ISERROR(VLOOKUP(BCR!A2,MKS!$A$2:$A$972,1,FALSE )),"Did not
Match",VLOOKUP(BCR!A2,MKS!$A$2:$A$972,1,FALSE))
Thanks!
--
mizzrizz
------------------------------------------------------------------------
mizzrizz's Profile:
http://www.excelforum.com/member.php...o&userid=35515
View this thread:
http://www.excelforum.com/showthread...hreadid=552969