Using IF statement compare cell ID with data in another column tru

C

connie

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")
 
M

Marcelo

hi Connie,

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

hth
regards from Brazil
Marcelo

"connie" escreveu:
 
M

Maistrye

connie said:
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")
Click to expand...

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

Scott
 
C

connie

I had already used the previous answer which worked.... thanks for a quick
response!
 
Top