Thread: Error comparing and getting result of between Two columns
View Single Post
 
Old 06-18-2014, 07:35 PM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default
That way:
=IF(A2="","Empty",IF(COUNTIF($B$2:$B$12,A2)>0,"Yes","No"))
The example sticks to the first description of yours, somehow you got the sample-list mixed up
Reply With Quote