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