Autotick a check box in excel if same info found in a column

[davids4500]

I have an excel spreadsheet with two sheets. Data sheet and Scan sheet. In the scan sheet I have product codes in A2:A999.
In the data sheet I have product codes in A2:A250. In Column C of the data sheet I have checkboxes.
I need a formula that if the product code in data worksheet A2 matches a code in scan worksheet A2:A999 then the checkbox in data worksheet C2 is ticked.
Thank you

 

[iggydarsa]

Each check box can be associated with a cell if use a Format Control Checkbox rather than ActiveX.

Right Click on the checkbox, select "Format Control" and under "Control" tab where it says "Cell Link", select a cell.

Then go to that cell and type this formula:

=IF(ISERROR(VLOOKUP(DATA!A2, SCAN!A:A, 1, FALSE)), FALSE, TRUE)

and viola!

but if you use ActiveX checkbox then I dunno an easy way.

 

[davids4500]

Each check box can be associated with a cell if use a Format Control Checkbox rather than ActiveX.

Right Click on the checkbox, select "Format Control" and under "Control" tab where it says "Cell Link", select a cell.

Then go to that cell and type this formula:

=IF(ISERROR(VLOOKUP(DATA!A2, SCAN!A:A, 1, FALSE)), FALSE, TRUE)

and viola!

but if you use ActiveX checkbox then I dunno an easy way.

T