Thread: Using IF statement compare cell ID with data in another column tru
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maistrye Maistrye is offline
external usenet poster
  
Posts: 1
Default Using IF statement compare cell ID with data in another column tru

connie Wrote:
ex. IF cell C2 is listed in column F need to state 'True' or 'False'.
Here
is what I typed, however, it is not working correctly. Help!
=IF(C2=F:F,"true")

Try: =IF(Match(c2,F:F,0),"true")

Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=563836

Reply With QuoteReply With Quote