<div>
Please post a workbook with data
</div>


<div>
<div class="content wysiwyg-content">
Need to identify if info on sheet 'IDs NOT ON SHEET' exist on sheet '2018_04_02 data dump'<br />
<br />
I have a list of numbers in column A on sheet 'IDs NOT ON SHEET'<br />
and I want to find out in there is a match to column H on sheet '2018_04_02 data dump'<br />
<br />
I would like to have a 'Match' or 'No Match' appear in column D on sheet 'IDs NOT ON SHEET' if there is a match or no match
</div>
</div>


Need to identify if info on sheet 'IDs NOT ON SHEET' exist on sheet '2018_04_02 data dump'

I have a list of numbers in column A on sheet 'IDs NOT ON SHEET'
and I want to find out in there is a match to column H on sheet '2018_04_02 data dump'

I would like to have a 'Match' or 'No Match' appear in column D on sheet 'IDs NOT ON SHEET' if there is a match or no match

Compare two columns on different sheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.