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!