Using Excel 365

Please see attached.

I would like to know how to set up a formula/function in Sheet2, cell B2 that will search column A in Sheet1. If a company in Sheet1 matches a company in Sheet2, it will return TRUE or FALSE.

For Example-Sheet2:
Cell B2: FALSE


Cell B3: TRUE
Cell B4: FALSE

Your help is greatly appreciated.

Karen

Attached Files

Excel Sample.xlsx (10.4 KB, 10 views)

I am using my cellphone soI can't work on your attached sample. Try this in B2
=IF(COUNTIF(Sheet1!A$2:$A$14,A2)>0,"TRUE","FALSE")
Copy down.

IF() is not needed.
will do fine.

Right Arvi. Thank you.

Thank you both for your help!


Karen

I was wondering if this would be possible.

I modified the file and re-uploaded a new file.

I added a "Yes / No" column in column F. If "Yes" is typed into cell F2, cell range A2:F2 gets highlighted with (let's say) a yellow fill.

I'm very curious to see if this is possible.

Your help is greatly appreciated.

Karen

Yes Karen. A2:F2 could be highlighted with yellow through conditional formatting. Select A2:F2, in the ribbon of the Home tab, open Conditonal Formatting>Formula>type this formula in the box:
=($F2,"Yes")
Click Format>Fill>select yellow color>ok
Again, this is a cellphone so I am not sure if the formula works okay.
Edit: The formula should be:
=($F2="Yes")

Thank you so much Marcia! This worked great!


So if I want to apply this conditional formatting to each subsequent row in column F if a user types in "Yes" to F2:F15, how would I apply it?


Thank you again for your help.


Karen

Click conditional formatting>manage rules>in the apply to, change F2 to F15. Or, select A2:F15, then repeat the conditional formatting process.

Thank you so much Marcia!

How exactly does this formula work?
=COUNTIF(Sheet1!A$2:$A$14,$A2)>0

Karen, google COUNTIF and you'll find excellent websites providing detailed explanations. I go direct to Exceljet.