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

try
=if(iserror(vlookup(c2,f:f,1,0)),"false","true")

hth
regards from Brazil
Marcelo

"connie" escreveu:

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")
Reply With QuoteReply With Quote