Hi,
Worksheet 1 Cell A1 has text or a value.
I need to be able to see if that text or value has an exact duplicate in Worksheet 2 anywhere from Cells A1 to A500. If so I want to be able to record "yes" in Worksheet 1 Cell B1.
Thanks
Hammer
Hi,
Worksheet 1 Cell A1 has text or a value.
I need to be able to see if that text or value has an exact duplicate in Worksheet 2 anywhere from Cells A1 to A500. If so I want to be able to record "yes" in Worksheet 1 Cell B1.
Thanks
Hammer
Last edited by hammer2; 09-19-2011 at 07:08 PM.
Hammer,
You can use the following:
=IF(ISNUMBER(MATCH(A1,Sheet2!$A$1:$A$500,0)),"yes","no")
Hope that helps,
~tigeravatar
Brilliant!!
Thanks heaps tigeravatar.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks