Compare cell between wkshts - not working

  • Thread starter Thread starter miker1999
  • Start date Start date
M

miker1999

Hello,
I am trying to add 2 cells together in one worksheet and then searc
the columns of another worksheet to see if it finds a match. If i
finds a match, I would like to say "FOUND MATCH"...if not, "NO MATCH".
I can get this formula to work, but it is not accurate (it doesn't fin
most of the matches...and I know for sure they match, I rigged th
data). Help!

Here if my formula:

This is in worksheet name 'Transfers'. The other worksheet i
'1-OPEN'.

=IF(C3&D3='1-OPEN'!T:T,"FOUND MATCH","NO MATCH")

Thanks!
Mik
 
I'm assuming when you say 'add' you mean concatenate, and that it is not
numerical values we are dealing with here but text. If that is so, then try
this:-

=IF(COUNTIF('1-OPEN'!T:T,"*"&C3&D3&"*"),"FOUND MATCH","NO MATCH")

This will search within text values as well and doesn't need th cell contents to
contain only C3&D3, so if you don't need it to do that then you can have just:-

=IF(COUNTIF('1-OPEN'!T:T,C3&D3),"FOUND MATCH","NO MATCH")
 
Back
Top