Formula to search column for data and return true or false

[missyvette]

I need to create a formula that will look at a 10 digit number in column S of Sheet 1 and see if it appears in row A of sheet 2. If it finds the exact number in column A of sheet 2, I want it to return a true value, if it doesn't find it, I want it to return a false value.

Is this an IF function or a LOOKUP function?

 

[Redwolfx]

=If(Countif(Sheet2!A:A,S1)>0,"True","False")

 

[NeonRedSharpie]

Row A or column A in sheet 2?


For Column A:

=IF(ISERROR(VLOOKUP(S1, Sheet2!A:A,1,0)), FALSE, S1)

For Row A (Row 1):

=IF(ISERROR(HLOOKUP(S1, Sheet2!1:1,1,0)), FALSE, S1)

 

[Aladin Akyurek]

I need to create a formula that will look at a 10 digit number in column S of Sheet 1 and see if it appears in row A of sheet 2. If it finds the exact number in column A of sheet 2, I want it to return a true value, if it doesn't find it, I want it to return a false value.

Is this an IF function or a LOOKUP function?

=ISNUMBER(MATCH(S2,Sheet2!A:A,0))

would be adequate and fast.

 

[missyvette]

=If(Countif(Sheet2!A:A,S1)>0,"True","False")

Sweet!! This worked! Thanks - never would have thought of Count!

I love this site.

 

[missyvette]

Thank you!! This one would have worked for me except I should have mentioned that I want to identify what the true and false values are.

 

[missyvette]

=ISNUMBER(MATCH(S2,Sheet2!A:A,0))

would be adequate and fast.

Thank you!! This one would have worked for me except I should have mentioned that I want to identify what the true and false values are. Can I do this?

Sorry I should have mentioned this.

 

[Aladin Akyurek]

Thank you!! This one would have worked for me except I should have mentioned that I want to identify what the true and false values are. Can I do this?

Sorry I should have mentioned this.

IsNumber/Match will automatically give you TRUE when a match is successful and FALSE otherwise. The formula is faster than a COUNTIF set up.

 

[Redwolfx]

Glad that this worked for you. Thanks for the feedback

 

[Aladin Akyurek]

Glad that this worked for you. Thanks for the feedback

Just in case:
http://www.mrexcel.com/forum/excel-questions/38643-auto-flag-list.html#post178581