Formula to reference data between 2 excel sheets

[jtmbell]

I have a very large spreadsheet with multiple sheets (all named differently). I have a master list (Master) and a new sheet each day (saved as the date - 3.5.18). I am needing a formula to input into the daily sheet that will tell me if the number listed in column A is also listed on the master sheet.
Example:

Master sheet -
Column A has 100 rows of item numbers

Daily sheet - 3.5.18
Column A has 200 rows of item numbers.

If the item number from the daily sheet is on the master sheet I need an X or a 1 in column DK.


All help is GREATLY Appreciated!

 

[Joe4]

For the item in cell A2 of your Daily sheet, place this formula in cell DK2:

=IF(COUNTIF(Master!A:A,A2)>0,"X","")

and copy down for all rows.

 

[jtmbell]

Thank you! This worked perfectly!

 

[Joe4]

You are welcome!